Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you drop the line in a line graph?
Line graph for actual goal from January through August--the line graph for
Sept-Dec follows the formula for August. I would like the line graph to stop at August--and only appear as I put the actual date in for each month. Can this be done?????? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you drop the line in a line graph?
Suppose you have Jan thru Dec in A1:A12 and values in B1:B8 (Jan to Aug).
Fill B8:B12 with =NA() -this shows as #N/A- and make the chart using A1:B12 The N/A values are ignored by Excel's chart. As you add new values they will appear on the chart OR make a dynamic chart; see http://people.stfx.ca/bliengme/ExcelTips/Dynamic.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "LisaM" wrote in message ... Line graph for actual goal from January through August--the line graph for Sept-Dec follows the formula for August. I would like the line graph to stop at August--and only appear as I put the actual date in for each month. Can this be done?????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Markers only appearing on comparison line graph | Charts and Charting in Excel | |||
Combination Line and Bar Graph | Charts and Charting in Excel | |||
Line graph for cumulative number over time | Charts and Charting in Excel | |||
Line Graph Help | Charts and Charting in Excel | |||
Possible to Add Horizontal Line to Embedded Graph via VBA? | Charts and Charting in Excel |