Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Two Axis Column Chart Anomaly (2003 SP3)

    This is very strange to me, but then a lot of this is hard for me. I have a graph in Excel, that uses two Y-Axis with one X-Axis.
    The common X-Axis is 2005, 2006, 2007, and 2008 which are the years. One set of Y-Axis uses dollars and the second shows count.
    For some reason the second category axis has the correct data, but the labels are incorrect. It starts at 2006, instead of 2005, although the data is correct. It is only the labels for the second category axis that is wrong.

    Any ideas what I am doing wrong? I have attached "Source Data" screen.

    Thanks!

    Ken
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Two Axis Column Chart Anomaly (2003 SP3)

    Your description is confusing, you first mention that you have one X-axis, then that you have two category (=X) axes. Your screenshot shows two category axes. Why did you specify a second category axis if you want to use the same set of X-values for both series?

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Two Axis Column Chart Anomaly (2003 SP3)

    Hans,
    I am sorry for the poorly written description. I actually have two Y-Axes and only one X-Axis. I tried it with and without the second category axis with the same results. I do not need the "YEar" to show up in the table at the bottom of the chart, which is what I am trying to eliminate.

    I hope that better explains my problem.

    Thanks,
    Ken

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Two Axis Column Chart Anomaly (2003 SP3)

    Could you attach a sanitized copy of the workbook with the chart?

  5. #5
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Two Axis Column Chart Anomaly (2003 SP3)

    Hans,

    I went to a different workstation to create the scaled down version, and everything was perfect. I don't know why, but it was on the same server. I will open back up on the first workstation this afternoon to see if the problem is still there on that pc. This is just very weird to me.

    Thanks for your help.

    Ken

Posting Permissions

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