Adding a line to a bar chart

A

Aurora

I am using Excell 2003.
I have a chart with 4 years of Sales $$ information in a vertical bar chart.
Now I have to add a Goal line to the chart for the current year's information.
I changed the chart to a "custom line - column plotted on 1 axis". But the
graph turned into 3 columns and 2 lines. The the $$ infor for the current
year and turned from a bar into a line. How do I change this line back into
a bar? Can anyone help me. I am on a tight schedule to complete a series of
these types of changes today.

Aurora
 
J

Jon Peltier

This is a combination chart, and believe me, once you know how to make your
own, you'll never use the clumsy built-in ones.

Create your chart with all columns. Then select the series you want to
change, go to Chart menu > Chart Type, and choose a line style that you
like. Ta-Daa!

Another option if you're not too rushed is one of these techniques to add a
line across the whole chart:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top