I have attached a test file that has 12 months on the horizontal axis but data for Jan to Mar only. I would like display the chart with only the three months and not the months where there is no data?
Thanks in advance
I have attached a test file that has 12 months on the horizontal axis but data for Jan to Mar only. I would like display the chart with only the three months and not the months where there is no data?
Thanks in advance
Last edited by Aland2929; 02-11-2012 at 07:24 AM.
You can apply a filter to column B, and unselect #N/A in the drop-down.
Hope this helps.
Pete
Thanks. That works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks