Results 1 to 10 of 10
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    overlay charts (2003)

    I have a user that has an area chart in his spreadsheet.
    He has another data series which he wants to plot OVER the area chart, but as a line (actually, the points create a slight curve).
    The only way we've been able to do this is another area chart, with no fill, but the result has red lines around the borders.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: overlay charts (2003)

    If you plot the line on a secondary Y axis you can do that.
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: overlay charts (2003)

    You can add the series to the original area chart, either by dragging the source data onto the chart, or by clicking on the chart, then selecting Chart | Add Data...
    The new series will be displayed as an area series.
    Next, click once on the new series to select it, then select Chart | Chart Type, and select Line Chart.
    Select the desired subtype, and click OK.
    The change will only be applied to the selected series, not to the entire chart.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: overlay charts (2003)

    I must be doing something wrong because when I clicked on the second area chart (which I want as a line) and changed the type to line, the new line was very "fuzzy".
    Is there a setting I'm missing that would make it a continuous line like it shows when it's an area chart?

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

    Re: overlay charts (2003)

    Could you post a copy of your workbook, zipped if necessary (and with sensitive information removed)?

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: overlay charts (2003)

    Post deleted by kweaver

  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: overlay charts (2003)

    Dbl click on the line and remove the marker. The "X" as marker is so frequent is adds the fuzziness. Just keep the line...

    Steve

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: overlay charts (2003)

    It's the point markers that are causing that effect. If you remove them, it will be a plain line. (or you can make them smaller)
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: overlay charts (2003)

    The fuzziness is caused by the markers of the data points.
    Click on the series again, select Chart | Chart Type again, and select a sub type without markers, the first sub type.
    Attached Images Attached Images
    • File Type: png x.png (2.6 KB, 1 views)

  10. #10
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: overlay charts (2003)

    bingo...that was the issue. Thanks for the extra sets of eyes.

Posting Permissions

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