Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Insert two points horizontal
I need to insert a shaded area to show if my data is falling between two
points. I have 12 months on the axis and vertical numbers reflecting amounts done. I want a bar that show if we met the lowest goal and another to show if we meet exceeded the highest amount. Average number would be 430 and it should fall inbetween 420 and 450. Is it possible to do this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Insert two points horizontal
You could use a technique like this to add several horizontal lines (min,
max, target): 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 _______ "wcurtis" wrote in message ... I need to insert a shaded area to show if my data is falling between two points. I have 12 months on the axis and vertical numbers reflecting amounts done. I want a bar that show if we met the lowest goal and another to show if we meet exceeded the highest amount. Average number would be 430 and it should fall inbetween 420 and 450. Is it possible to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate points for and points against | Excel Worksheet Functions | |||
Horizontal Lines | Excel Discussion (Misc queries) | |||
INSERT HORIZONTAL PAGEBREAK AFTER EACH LINE IN ENTIRE WORKSHEET . | Excel Worksheet Functions | |||
How do I find points on a curve between known points? | Excel Worksheet Functions | |||
Insert horizontal line/single cell in Excel? | Excel Discussion (Misc queries) |