UNSOLVED
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.
- 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
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?
abach
1728 Posts
217
0
Posted February 16th, 2004 20:00