Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    allyn, Washington, USA
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't add values to chart (Excel 2000)

    I have a simple chart that has dates in column A & data in col B. I entered new values in line 20, col's A & B, then changed the source data in my chart so the new values would plot, but they don't show up. Then I thought I'll just make a new chart from the data. The new chart is a mystery. The Y ordinate displays percent, not the values, and the line chart doesn't at all resemble the original chart. I have duplicated the source data inputs from those in the correct (except for not adding the new data) in the new chart.

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

    Re: Can't add values to chart (Excel 2000)

    Could you post (a copy of) the workbook? Remove or modify sensitive data.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    allyn, Washington, USA
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't add values to chart (Excel 2000)

    How do I do that?

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

    Re: Can't add values to chart (Excel 2000)

    The page in which you compose a reply has a box to enter the path for an attachment and a Browse... button to select the file.
    The file must be less than 100 KB; if the workbook is larger, you can zip it.
    Note: delete worksheets and data that are not needed to illustrate the problem.

  5. #5
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    allyn, Washington, USA
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't add values to chart (Excel 2000)

    <P ID="nt"><font size=-1>(No Text)</font>

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

    Re: Can't add values to chart (Excel 2000)

    There is something very strange about your new chart, I don't understand what's going on there.
    The original chart has a fixed maximum for the x-axis: it stops at June 1, 2005. You must either make the maximum automatic, or set it to a date in 2006. To do this, double click the dates below the x-axis to open the Format Axis dialog. Activate the Scale tab and either tick the check box for Maximum, or enter an appropriate date.
    Unfortunately, you'll have to adjust the arrows and text boxes, they won't be in the correct places any more.

  7. #7
    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: Can't add values to chart (Excel 2000)

    Change the type from a "100% stacked line" to something else (like a "Line"). The series are always normalized to 100% and with only 1 series it is just 100% in the chart you selected.

    Steve

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

    Re: Can't add values to chart (Excel 2000)

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

  9. #9
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    allyn, Washington, USA
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't add values to chart (Excel 2000)

    Thanks Hans & Steve. Both solutions worked fine.

  10. #10
    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: Can't add values to chart (Excel 2000)

    Don't feel bad, it took me a while also to figure it out. I had never used it.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>To be honest, I am not sure when someone would want to use it. To me it is not intuitive and is bound to give the wrong impression...

    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
  •