How can I chart a data series without showing empty cells?

Brent · January 19th, 2006, 03:10 PM posted to microsoft.public.excel.charting

I have several data series with values for each day of the week. Some weeks
there will be a value for Saturday in some of the data series, while other
Saturday cells will remain empty. How can I chart these series and not show
gaps for the empty cells?
--
Brent

Bernard Liengme · January 19th, 2006, 03:38 PM posted to microsoft.public.excel.charting

If it is a Line chart, try:
Replace the empty cell with =NA()
or
With chart select, use Options|Chart and specify what you want for "plot
empty cells"

For Column chart: use Chart Option (right click chart to open a menu), on
Axis tab set to Category rather than Auto or Time Series

best wishes--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Brent" wrote in message
...
I have several data series with values for each day of the week. Some weeks
there will be a value for Saturday in some of the data series, while other
Saturday cells will remain empty. How can I chart these series and not
show
gaps for the empty cells?
--
Brent

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
checking that cells have a value before the workbook will close	kcdonaldson	Worksheet Functions	8	December 5th, 2005 04:57 PM
How do I save an access document in word document?	cmartin	General Discussion	2	September 13th, 2005 11:26 PM
How do I get 3 series in sync with the x-axis?	zizbird	Charts and Charting	10	October 25th, 2004 01:23 PM
SQL view of messed up action queries	Kendra	Running & Setting Up Queries	2	August 31st, 2004 09:53 PM
Chart Source Data Ranges Changing when Data Sheet updated from text file source.	Tekn0	Charts and Charting	3	January 8th, 2004 04:45 PM