Skip to main content
Start a Conversation

Unsolved

This post is more than 5 years old

persus

9 Posts

5017

February 16th, 2004 08:00

Excel Charts

When designing a chart in MSExcel 2002, if the series includes the IF function giving a blank cell(s) (e.g. you might wish to add data on a weekly basis) Excel seems to read the blank cells as zero instead of as a blank, and the plot line, instead of stopping, drops to the x-axis.  Why is this, and is there anyway to stop it happening?   This does not happen when using Works. 

abach

1.7K Posts

February 16th, 2004 20:00

Do you want the chart to stop at the first blank value? But still want to add more information later?

persus

9 Posts

February 17th, 2004 15:00

Yes, I do want to add extra information later eg on a weekly basis.  The formula that is giving trouble is the IF function eg IF(E26="","",E25-5).  If E26 is a blank Excell reads the blank "" as a zero and the graph plot drops straight down to the x-axis. This does not occur in Works7

abach

1.7K Posts

February 19th, 2004 00:00

Interesting, as I cannot seem to find a way to stop the chart at the first " " it encounters. It would be possible with code, but I don't know if you're familiar with the VBA behind Excel.

persus

9 Posts

February 19th, 2004 07:00

No, unfortunately I do not know the language.  It is just strange that this only happens with Excel 2002 but not with Works7, for example.  I came across another oddity in that the INDEX function has changed its syntax since Works4.5 - the function reverses the positions of the row and column elements and I have had to rewrite all the formulae using using that function since transferring to Excel.

My other problem is that when I try to open my spreadsheets and associated charts (created in Works7), in Excel 2002, Excel 2002 only displays the spreadsheets and I can not obtain the associated charts.  Any ideas how I might 'open' the charts or where they could be stored?

Was this post helpful?

View All

No Events found!

Top