Home |
Search |
Today's Posts |
#1
|
|||
|
|||
X Axis puzzlement
Why, when I do a simple bar chart on this table:
Territory JUL AUG SEP 3 123 156 192 4 234 156 254 5 345 248 369 6 254 235 358 7 219 245 256 does the X axis show 1,2,3,4,5 and the Legend shows Territory But - when I replace 3-7 with NE, NW, SE, SW, C, the X axis shows NE, NW... and the legend only shows Jul, Aug, Sep (and drops Territory - as it should) I've changed the cell definition to text for the 3-7 - I'm sure there is something very obvious - I just can't grasp it. (It is Friday afternoon!) TIA Carole O |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |