Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jun 2006
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    X-Axis Label problem (2003)

    Hi,

    Attached file shows a simple table & generated graph.

    How come Excel replaces the Header with numbers. Those headers represent departments and I'd like Excel to place them on the x-axis.

    TIA.

    Bob.

  2. #2
    Lounger
    Join Date
    Jun 2006
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: X-Axis Label problem (2003)

    Also, even though 2 of them have a Zero value entry, I'd still like them to be in the Legend.

    Is this possible?

  3. #3
    Lounger
    Join Date
    Jun 2006
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: X-Axis Label problem (2003)

    Also just noticed that both the bars are in the same colour, though they should all have different colours for distinction.

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: X-Axis Label problem (2003)

    It's due to the merged cells and the fact your source data range is one cell to the right of your last column header.

    I've re-attached the sheet with the data source set to A1 to G2 instead of A1 to H2 (the area the wizard probably chose for you).

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: X-Axis Label problem (2003)

    I don't understand the need for the merged cells. This is part of the problem as it adds extra categories to the chart (you will notice the blank columns between each value).

    To make them separate colors, you can do it manually (but it will not make them separate in the Legend).

    I am unsure of why you need to have both the legend and the categories, but if you do, the data needs to be revamped (and then it will autmatically make them different). Here is an example

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •