Results 1 to 5 of 5
  1. #1
    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: Bug in Chart? (2003)

    If you post it with any confidential info removed, we can take a look at it

    Steve

  2. #2
    Star Lounger
    Join Date
    May 2002
    Location
    Juneau, Alaska, USA
    Posts
    63
    Thanks
    0
    Thanked 1 Time in 1 Post

    Bug in Chart? (2003)

    <P ID="edit" class=small>(Edited by patmoore on 06-May-04 10:35. )</P>I am attempting to build a line graph. My data set consists of three columns. A is a column of x-axis values ranging from -24 to +24. B is a column of data called grades, with values ranging from 0 to 36378.5, and C is a column of data called web ranging from 0 to 5655.5. When Excel creates the chart, it mixes up the data columns. The legend identifies grade and web by the appropriate colors (web is green, grade is blue), but when I attempt to click on the grade line, the points are labelled "Web point xx" while the line traces values from both web and grade. Have I set things up wrong, or is there some kind of bug in Excel's Chart function? I can send a data set to anyone who wants to play with it.

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Juneau, Alaska, USA
    Posts
    63
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Bug in Chart? (2003)

    Well! After going back in, I see the stuff at the bottom about how to add an attachment. Completely missed it before. I've edited the original post to include the data set and the graphs. The first looked at all the variables, the second eliminated all but two to try to see what was going on.

    Thanks for the heads up--Pat

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

    Re: Bug in Chart? (2003)

    You have set up the chart as a stacked line chart. Since the two series don't overlap in x-values (that's not correct but I hope you get my meaning) the stacked line represents web on the left and grade on the right. Setting the chart type to a standard line chart corrects the problem for me (Excel 2002 SP-2)

  5. #5
    Star Lounger
    Join Date
    May 2002
    Location
    Juneau, Alaska, USA
    Posts
    63
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Bug in Chart? (2003)

    Hans,
    Precisely! Thanks so much--I wondered why it looked ok yesterday afternoon and not right this morning. I must have inadvertently clicked the chart-type box while I was setting other parameters. It works fine now.
    The Lounge is wonderful!

    Pat

Posting Permissions

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