Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart wizard picks wrong data for axis
This is in Excel 2003.
I have a block of numbers in C104:I111, with columni labels in C103:I111 and row labels in B104:B111. I want to create a line chart with the rows as series and column labels as X-axis labels. When I highlight the information and click the chart wizard, it makes the columns the series and uses the row labels for the x-axis. I've tried selecting other text, but the wizard does it the same way every time. Is there a way to force the wizard to do what I want, instead of what it wants? Thanks. PS: I just upgraded from 2002, where I never had this problem, as far as I can remember. |
#2
|
|||
|
|||
First, clear cell C103. Second, in step 2 of the chart wizard, on the
Data Source tab, choose the By Rows option. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ jg wrote: This is in Excel 2003. I have a block of numbers in C104:I111, with columni labels in C103:I111 and row labels in B104:B111. I want to create a line chart with the rows as series and column labels as X-axis labels. When I highlight the information and click the chart wizard, it makes the columns the series and uses the row labels for the x-axis. I've tried selecting other text, but the wizard does it the same way every time. Is there a way to force the wizard to do what I want, instead of what it wants? Thanks. PS: I just upgraded from 2002, where I never had this problem, as far as I can remember. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
Dynamic bar chart, must ignore "n/a" data... | Charts and Charting in Excel | |||
pie-charting non-numeric data | Charts and Charting in Excel | |||
line chart displays wrong values | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |