Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Threshold Line Across Chart
I have a column chart that I created in Excel 2003. It plots percentages for
each month of the year. The data ranges from 22% - 34%. I want to add a line for my threshold that will go across the chart at 18%. How can this be done? HELP! Thanks, Karen |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Threshold Line Across Chart
Karen,
You can add another data series. -- Regards, Eddie http://www.HelpExcel.com "Karen" wrote: I have a column chart that I created in Excel 2003. It plots percentages for each month of the year. The data ranges from 22% - 34%. I want to add a line for my threshold that will go across the chart at 18%. How can this be done? HELP! Thanks, Karen |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Threshold Line Across Chart
There are a couple techniques:
http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Karen" wrote in message ... I have a column chart that I created in Excel 2003. It plots percentages for each month of the year. The data ranges from 22% - 34%. I want to add a line for my threshold that will go across the chart at 18%. How can this be done? HELP! Thanks, Karen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
bar chart with threshold | Charts and Charting in Excel | |||
putting in threshold line that easily depicts reaching a goal | Charts and Charting in Excel | |||
How do I show a threshold line in an Excel chart? | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |