Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP PLOTTING
was trying to plot two columns of data as below,
=SERIES(,'JAXXN Report'!$Q$14:$Q$73,'JAXXN Report'!$P$14:$P$73,1) but I only have values in the first 10 rows. and rest of the cells have equation to import values from other sheet. I think plot assuming all blank cells as zeros. How do I make the plot skip empty cells. But take them when values appear. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP PLOTTING
Replace the blanks by =NA() which will display as #N/A
These will be ignored by chart engine best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Raz" wrote in message ... was trying to plot two columns of data as below, =SERIES(,'JAXXN Report'!$Q$14:$Q$73,'JAXXN Report'!$P$14:$P$73,1) but I only have values in the first 10 rows. and rest of the cells have equation to import values from other sheet. I think plot assuming all blank cells as zeros. How do I make the plot skip empty cells. But take them when values appear. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP PLOTTING
Hi,
you can also filter the range to exclude blank cells. Since the blank cells will not be visible in the range, they will not be plotted at all. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Raz" wrote in message ... was trying to plot two columns of data as below, =SERIES(,'JAXXN Report'!$Q$14:$Q$73,'JAXXN Report'!$P$14:$P$73,1) but I only have values in the first 10 rows. and rest of the cells have equation to import values from other sheet. I think plot assuming all blank cells as zeros. How do I make the plot skip empty cells. But take them when values appear. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PDF plotting | Excel Discussion (Misc queries) | |||
getting an x-value from plotting a y-value | Excel Discussion (Misc queries) | |||
help on plotting | Excel Discussion (Misc queries) | |||
Help with plotting | Charts and Charting in Excel | |||
Plotting Dates | Excel Worksheet Functions |