+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    03-31-2004
    Posts
    2

    Smooth area chart possible?

    Hi Everyone,
    Does anyone know if it is possible to create an area graph that has smooth lines instead of jagged ones? I've searched everywhere and can't find any information on it. I will explain what I am trying to achieve as maybe there is another way. I have many series of data. I plot them on a smooth line chart and it looks good. What I am trying to do is shade the area between the lowest and highest values on the chart. Basically, I want to show each line individually but highlight the range using a background shading. What I have done so far is created two new series of data which is the calculated lower bound and upper bound and then plotted them on the graph. I thought that if I could change the type for the lower and upper bounds to an area chart, then I could simulate the shading by using a color for the upper bound and white(my background color) for the lower bound. It works, but the area chart type only comes with jagged edges, so it doesn't look good. Any ideas?

    Thanks!
    ItchyII

    I will not be defeated!

  2. #2
    "Eagle Eyed" Forum Moderator oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Work) and 2007 (Home)
    Posts
    7,130
    Hi,

    Take a look here and may be use an XY scatter chart with curved lines?

    http://peltiertech.com/Excel/Charts/XYAreaChart2.html
    oldchippy
    -------------


    If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    03-31-2004
    Posts
    2

    Thanks...but...

    I'll take a closer look, but it appears to me to be the same concept that I have already tried, except with a scatter instead of a line graph. It is basically suggesting that I layer a series of data as an area chart along with the scatter data. As soon as I use the area chart type, the edges become jagged.

    I'll keep looking....
    ItchyII

    I will not be defeated!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0