Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add a horizonal target/goal line to a line chart?
I am trying to add a horizontal target/goal line to a line chart that
contains two other data series. How do I add the line without including it in my data table that includes both data labels and legend keys? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add a horizonal target/goal line to a line chart?
Hi,
The data table will include all data series. With the legend you can select the individual legend entry and delete it. Adding datum lines http://www.andypope.info/charts/averageline.htm Deleting legend entries http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "excelbanker" wrote in message ... I am trying to add a horizontal target/goal line to a line chart that contains two other data series. How do I add the line without including it in my data table that includes both data labels and legend keys? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add a horizonal target/goal line to a line chart?
Make the chart with all of the series, including the goal line. Make sure
the target is the last series in the chart. Add the data table, so Target is the lowest in the table. Use a simplified formatting for the data table, for example, only use horizontal internal borders. Then go to the worksheet, and change the number format of the target cells to ;;; which will suppress their appearance in the worksheet and in the data table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "excelbanker" wrote in message ... I am trying to add a horizontal target/goal line to a line chart that contains two other data series. How do I add the line without including it in my data table that includes both data labels and legend keys? |
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 | |||
Creating a goal or target line | Charts and Charting in Excel | |||
How do I add a target line to a chart? | Charts and Charting in Excel | |||
target line in bar chart | Charts and Charting in Excel | |||
Chart Target Line | Charts and Charting in Excel |