titanium111 titanium111 is offline

Junior Member

Posts: 1

How to ignore blank cels in x axis

I would like to have a line chart that I change the x-axis values with an "if" statement.
Problem is number of x-axis values changes according to the selection (I want 12 periods of months or 8 Quarters according to the selection)
But I can not make my chart to ignore the last 4 blank cells automatically when I convert the the graph to Quarter view

Can anyone help?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ignore blank	vicki	Excel Discussion (Misc queries)	6	January 16th 09 06:01 AM
Ignore Y axis value	Neil	Charts and Charting in Excel	3	July 25th 08 07:53 PM
ignore blank	Naomi	Excel Discussion (Misc queries)	1	December 1st 06 12:55 PM
How to Ignore #N/As for X-Axis TickMarks?	Peter Bernadyne	Charts and Charting in Excel	4	May 22nd 06 03:23 PM
Autofill cels based on two dates in adjacent cels	William2	Excel Worksheet Functions	3	February 1st 06 10:57 PM

All times are GMT +1. The time now is 03:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us