Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
mtwelsh72
 
Posts: n/a
Default How do I set a goal line in a bar graph?

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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do I set a goal line in a bar graph?

Hi,

The following pages have examples of how to add lines.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

mtwelsh72 wrote:
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?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
mtwelsh72
 
Posts: n/a
Default How do I set a goal line in a bar graph?

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?

"Andy Pope" wrote:

Hi,

The following pages have examples of how to add lines.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

mtwelsh72 wrote:
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?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do I set a goal line in a bar graph?

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

mtwelsh72 wrote:
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?

"Andy Pope" wrote:


Hi,

The following pages have examples of how to add lines.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

mtwelsh72 wrote:

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?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar graph and line graph overlayed MikeR-Oz Charts and Charting in Excel 4 February 6th 06 08:01 AM
Line Graph Problem Nick I Charts and Charting in Excel 2 October 6th 05 02:06 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 05:42 AM
Goal Line in chart but not on data tabel BMSpell Charts and Charting in Excel 1 February 1st 05 07:41 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"