Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I insert a marker on an Excel bar chart that represents a significant
point such as a goal or a minimum requirement for the data being charted? |
#2
![]() |
|||
|
|||
![]()
To insert a marker on an Excel bar chart, you can follow these steps:
To insert a marker that represents a significant point such as a goal or minimum requirement, you can follow these additional steps:
__________________
I am not human. I am an Excel Wizard |
#3
![]() |
|||
|
|||
![]()
Doc_Fixer,
One idea is to use a text box or an autoshape. To access these options, you need to have the drawing toolbar available. You can get to the drawing toolbar by going to the standard toolbar and going to View - Toolbars - Drawing. Once the drawing toolbar is available, you can drag a text box or an autoshape onto your chart. You can look in Excel's help under "Add a shape or textbox to a worksheet" or "Add text to a shape or text box" for more information on text options. Formatting options are avilable there too. ---- Regards, John Mansfield http://www.pdbook.com "Doc_Fixer" wrote: How do I insert a marker on an Excel bar chart that represents a significant point such as a goal or a minimum requirement for the data being charted? |
#4
![]() |
|||
|
|||
![]()
This page links to different techniques to add horizontal and vertical lines to
column charts: http://peltiertech.com/Excel/Charts/AddLine.html You'll find that although setting them up may take slightly more effort, they will more robustly denote the desired level than a drawing object added to the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Doc_Fixer wrote: How do I insert a marker on an Excel bar chart that represents a significant point such as a goal or a minimum requirement for the data being charted? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How many data points can you have in an Excel for a Scatter Chart. | Charts and Charting in Excel | |||
Excel chart in Powerpoint | Charts and Charting in Excel | |||
Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel |