Hello,
In the example attached, I am looking to create a target line on a single bar graph.
Similar to a goal thermoter, but in this case the goal will be the amount to reduce the bar graph to.
Example, currently the bar graph is at 360, the goal to reduce to is 150.
How can I add a target line of 150 to a single bar graph that stretches the width of the bar graph?
Thank you, I appreciate any help.
Nick
Refer attach photo, you required like this.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Like this?
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Then you calculate difference between two value 360 - 150 = 210 in cell & select the data range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks