Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar graph and line graph overlayed | Charts and Charting in Excel | |||
Line Graph Problem | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
Goal Line in chart but not on data tabel | Charts and Charting in Excel |