Help with area chart - need vertical line added
I'm not sure if this is the best chart to use or not, but I'm plotting my
data in a Stacked Area chart. I need to show a vertical line at the "Median" value as shown below. So I have the "CB Score Groups" along the horizontal axis and the "# of accts" along the vertical axis. My Median score is 709. How can I add this as a vertical line? "CB Score Group" "# Accts" 0 - 599 550 600 - 619 281 620 - 639 448 640 - 659 643 660 - 679 803 680 - 699 946 700 - 719 899 720 - 739 853 740 - 759 742 760 - 779 872 780 - 799 691 800 - 819 375 820 - 839 143 = 840 11 Thanks! |
Help with area chart - need vertical line added
This approach should work on an area chart:
Add a Line to a Column or Line Chart http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ klandes wrote: I'm not sure if this is the best chart to use or not, but I'm plotting my data in a Stacked Area chart. I need to show a vertical line at the "Median" value as shown below. So I have the "CB Score Groups" along the horizontal axis and the "# of accts" along the vertical axis. My Median score is 709. How can I add this as a vertical line? "CB Score Group" "# Accts" 0 - 599 550 600 - 619 281 620 - 639 448 640 - 659 643 660 - 679 803 680 - 699 946 700 - 719 899 720 - 739 853 740 - 759 742 760 - 779 872 780 - 799 691 800 - 819 375 820 - 839 143 = 840 11 Thanks! |
Help with area chart - need vertical line added
thanks....I have my vertical line now, but I can't get it exactly where I
want it on the chart. My x values are text - a range of scores. I need my vertical line to be exactly where 709 would fall in that range. Right now it appears where the 700-719 range crosses. Is this impossible? "Jon Peltier" wrote: This approach should work on an area chart: Add a Line to a Column or Line Chart http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ klandes wrote: I'm not sure if this is the best chart to use or not, but I'm plotting my data in a Stacked Area chart. I need to show a vertical line at the "Median" value as shown below. So I have the "CB Score Groups" along the horizontal axis and the "# of accts" along the vertical axis. My Median score is 709. How can I add this as a vertical line? "CB Score Group" "# Accts" 0 - 599 550 600 - 619 281 620 - 639 448 640 - 659 643 660 - 679 803 680 - 699 946 700 - 719 899 720 - 739 853 740 - 759 742 760 - 779 872 780 - 799 691 800 - 819 375 820 - 839 143 = 840 11 Thanks! . |
Help with area chart - need vertical line added
If you have a 700-719 range, then you don't really have a 709 value, do you?
- Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ klandes wrote: thanks....I have my vertical line now, but I can't get it exactly where I want it on the chart. My x values are text - a range of scores. I need my vertical line to be exactly where 709 would fall in that range. Right now it appears where the 700-719 range crosses. Is this impossible? "Jon Peltier" wrote: This approach should work on an area chart: Add a Line to a Column or Line Chart http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ klandes wrote: I'm not sure if this is the best chart to use or not, but I'm plotting my data in a Stacked Area chart. I need to show a vertical line at the "Median" value as shown below. So I have the "CB Score Groups" along the horizontal axis and the "# of accts" along the vertical axis. My Median score is 709. How can I add this as a vertical line? "CB Score Group" "# Accts" 0 - 599 550 600 - 619 281 620 - 639 448 640 - 659 643 660 - 679 803 680 - 699 946 700 - 719 899 720 - 739 853 740 - 759 742 760 - 779 872 780 - 799 691 800 - 819 375 820 - 839 143 = 840 11 Thanks! . |
All times are GMT +1. The time now is 08:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com