Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart to zero
Hi
I am extracting data from Jan shhet into summary sheet, and from that summary sheet creating a line graph Formula in cell reads =INDIRECT("'"&(B1)&"'!c5")). This returns a "0" . The graph looks ugly dropping down to the zero when no data, so looked in previous threads and now in cell formula reads =IF(INDIRECT("'"&(B1)&"'!c5")="",(na),INDIRECT("'" &(B1)&"'!c5")) When value in the Jan sheet is 0, the summary sheet is populated correctly, and the graph shows the line ok, however, when no value is in Jan sheet, I get #NAME? error, and line still shoots to zero any idea's why? or how i can stop the line shooting to zero, unless 0 is in the origonal cell Help is appriciated regards Brian -- Message posted via http://www.officekb.com |
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 | |||
How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | 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) |