 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008x-axis in Excel 2008
How do I get at the data range for the x-axis in Excel 2008. I can see where to change y-axis data, but not x-axis. I'm coming from Excel 2000 for Windows where I could get to all of my data from the Chart:Source Data box. I'll try again with this question. Anybody know how to change the values Excel 2008 uses for the x-axis? This had us stumped for a while during working on a finance assignment for university. We were using a line graph. You can set values for the labels by selecting one of the lines on the graph and looking to the Formula Bar up top. You'll see a function with three parameters, except only two are present. The parameters are ranges. If you find the empty parameter (i.e. the bit between the commans in something that looks like RANGE(A1:A10),,RANGE(B1:B10) ) then you can manually input a range of data to use for the x-axis label. However, this does not apply a continuous data range, unfortunately. It just uses the source data to get labels. We had a set of data that represented profit and loss for x number of items sold (a break even analysis), with the number of items sold incrementing in steps of 10 (e.g. 0, 10, 20, 30, ...) up until 100, where the step changed to 20. Since the chart only used the source data as discrete text labels, the graph lines took a sharp upturn after 100, so we had to insert new lines to make sure that the graph appeared correctly. Bottom line, that's how you do it, but you can't get continuous data for a line graph like that (i.e. have the x-axis represent and model a range of values), just a set of labels that are treated as text. Microsoft really dropped the ball with Office 2008 for Mac. Apologies if this is hard to understand, it's 02:30 and I can't get to sleep :P Dru > I'll try again with this question. Anybody know how to change the values Excel 2008 uses for the x-axis? How cumbersome, I hope that Microsoft puts back the box for the x-axis series! BTW, 02:30!? is that the U.K.? It is indeed the U.K. > BTW, 02:30!? is that the U.K.? Druadan: THANK YOU for figuring that out. I was racking my brain trying to complete a take-home final. I'm so glad to see that Microsoft took something so intuitive (old chart wizard) and "improved" it. You saved my bacon. > Druadan: THANK YOU for figuring that out. I was racking my brain trying to complete a take-home final. > > I'm so glad to see that Microsoft took something so intuitive (old chart wizard) and "improved" it. > > You saved my bacon. This is absolutely brutal. I am really thinking of downgrading to the old version of excel. I had already figure out to change the range, but thought I was missing something.... > Druadan: THANK YOU for figuring that out. I was racking my brain trying to complete a take-home final. > > I'm so glad to see that Microsoft took something so intuitive (old chart wizard) and "improved" it. > > You saved my bacon. > I am really thinking of downgrading to the old version of excel. You might try updating to 12.1.0 first... Awesome, I just got the Mac:2008 SP1 update and I now have control back of the x-axis from the source data box and no longer have to use Druadan,s work around. Thanks Druadan |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.