LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Carole O
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
can't change how data on 2nd axis is being displayed Rebekah Charts and Charting in Excel 1 May 4th 05 02:51 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM


All times are GMT +1. The time now is 11:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"