How do I set a goal line in a bar graph?

G

Guest

I have a bar graph that graphs percentages to goal, I would like to display a
line within the bar graph that represents the goal. If possible, I would
then like to have the background of the graph below the goal line to be red,
and above the goal line to be another color. Can this be done?
 
G

Guest

Thank you Andy.

I am almost there. I am having a difficult time finding the "uncheck values
cross between categorys" section in the the formatting windows. I'm using
Excel 2003, would it be called something different?

Currently my spreadsheet shows the bars (performance) and I have the line
representing their goal, however, it does not go from edge to edge. It
currently goes from the first performance to the last performance.

Can you help?
 
A

Andy Pope

To get the line to go from edge to edge you will need to put it on the
secondary axis. Then you Chart options to enable the secondary X axis.
Double click the secondary x axis and on the scale tab you should find
the crosses between categories.

Cheers
Andy
 

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

Similar Threads

Creating a goal or target line 1
Bar Graph with goal line 1
How do you drop the line in a line graph? 1
Putting a line in a Bar Graph 3
Inserting a 'Standard' 3
Creating a custom chart [Excel 2003] 2
Adding a line to a bar chart 1
Access Combination Chart Types Access 2010 0

Top