Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizonal category axis
I want to take the years that are in cells B3-F3 and put them on the
horizontal axis. The directions say to edit the data source so that horizontal category axis uses the years in range B3:F3. Can someone help me? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizonal category axis
Typically, when you are setting up the range to be charted, the top line, in
your case row 3, contains data for the horizontal axis, then the data follows in contiguous rows/cells, row 4 and below contain the data to be plotted. If your years are in a separate section of the worksheet it is likely not to work. If the data is not contiguous use the control key to highlight the sections. The highlighted sections must form a rectangle, e.i. line up. See the help section on creating charts. "formulaconfusion" wrote: I want to take the years that are in cells B3-F3 and put them on the horizontal axis. The directions say to edit the data source so that horizontal category axis uses the years in range B3:F3. Can someone help me? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Horizonal bar chart with secondary axis problem | Charts and Charting in Excel | |||
Chart templates treates value axis as a category axis | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel |