Solved: Excel 2003 - how to change a chart data series from "area" to "line"??

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

gurutech

Thread Starter
Joined
Apr 23, 2004
Messages
2,960
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!
 
Joined
Oct 20, 2004
Messages
7,837
Hi, can you post your file? Or, if confidential, something similar so we (ok, so I) can get a better handle on exactly your problem is?
 

gurutech

Thread Starter
Joined
Apr 23, 2004
Messages
2,960
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.
 

gurutech

Thread Starter
Joined
Apr 23, 2004
Messages
2,960
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!
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top