ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do I add a goal line for a bar chart? (https://www.excelbanter.com/charts-charting-excel/228073-how-do-i-add-goal-line-bar-chart.html)

Tuucan

how do I add a goal line for a bar chart?
 
I have 8 bars that represent 0% to 100% standing vertically. I want to have
a line drawn horizontally that is at the 80% mark. Is there an easy way to
add a line? I have looked at all of the info and have yet to achieve the
process. I changed one bar i named "Goal" to a line, but it was just that, a
small line the width of the other bars and it did not show very well. I just
want a simple bar to show the goal.

Jon Peltier

how do I add a goal line for a bar chart?
 
http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Tuucan" wrote in message
...
I have 8 bars that represent 0% to 100% standing vertically. I want to
have
a line drawn horizontally that is at the 80% mark. Is there an easy way
to
add a line? I have looked at all of the info and have yet to achieve the
process. I changed one bar i named "Goal" to a line, but it was just
that, a
small line the width of the other bars and it did not show very well. I
just
want a simple bar to show the goal.





All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com