Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some line graph charts where the the first data point in drawing a line from zero. Thi coul imply the first value is zero but its not.
Example data would be A1 = , A2 = , A3 = 5, A4 = 6, A5 = The line graph in my mind should plot the values 5,6 and 7 however it is assuming A2 = 0 and is drawing this line. To shed a little more light on this the data source is derived from a custom function where I have told it to return "" if in error. Is this the problem? Is there a way to return nothing from a function so the cell is really empty Another consideration is that the solution cannot ingore zeros as there are cases these need to be plotted. Essentually I believe I nee to know how to deal with a non-result... Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Plot Data with X, Y values on Chart | Excel Discussion (Misc queries) | |||
How to plot chart where X axis values START 1 | Charts and Charting in Excel | |||
how do I setup a pie chart that does not plot zero values ? | Charts and Charting in Excel | |||
Unable to Plot Values on Chart | Charts and Charting in Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) |