Tech Support Guy banner
Status
Not open for further replies.
1 - 7 of 7 Posts

·
Registered
Joined
·
2,960 Posts
Discussion Starter · #1 ·
I have a chart in an Excel spreadsheet, and it has several "series" in it. Some of the series are charted as "lines", and some are "areas" that fill in the entire background of anything from 0 to the value I have entered.

I have one particular series that is showing up as an "area" but I want it to be drawn as a "line" instead, so it DOESN'T fill in the area below it. I currently have the "background" as "none", but now I have a line from the last value down to "0", and that's what I want to avoid...

Thanks in advance!
 

·
Registered
Joined
·
2,960 Posts
Discussion Starter · #5 ·
I'll get something posted up tomorrow. It is a "work" file, but doesn't contain anything confidential (yet). It's just a template I was working on.
 

·
Registered
Joined
·
2,960 Posts
Discussion Starter · #6 ·
In a bit of genius, I fixed it...

Right-click on the data source (the area), then choose "Chart Type", then change from "Area" to "Line" and save...

Don't know why I didn't think of that before!
 
1 - 7 of 7 Posts
Status
Not open for further replies.
Top