Hi
How can I have fixed upper and lower target line in my chart as below, if i ignore two column that show this values for correspond chart items?
thank you in advance,
\1
Hi
How can I have fixed upper and lower target line in my chart as below, if i ignore two column that show this values for correspond chart items?
thank you in advance,
\1
What you have doesn't work?
You can have a lower limit and upper limit in the scale properties of Y axis of the chart. And then you can tell it to cross x axis at your lower limit number. And then use text labels to name them, that's all I can come up with.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
If you mean you only want to enter the Min/Max values for the first and last item then you can do that.
After you have created the chart use ribbon
Chart Tools > Design > Data > Select Data > Hidde & Empty Cells > Connect data point with line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks