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!
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
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks