#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Charts

If you arrange the data to be in columns going down, i.e.:

Jan 15
Feb 0
Mar 22

and used 0 for no value, then you could apply a custom filter for not
equal to zero to hide the row - it will not show on the graph.

Alternatively, leave the cell blank.

Hope this helps.

Pete

On Oct 1, 9:19 am, Jithu wrote:
Hi,

Is it possible to eliminate cells without value (Say NA) while creating bar
charts?

eg jan Feb march
15 NA 22

so in Feb i want value as NA.(or the chart should not have feb data point)
this is a fixed chart and source data gets updated every month...

thanks in advance for your valuable time and advice..

Jithu



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
related to PIE charts N BAR charts manish Charts and Charting in Excel 2 June 26th 07 09:31 AM
related to PIE charts N BAR charts manish Excel Discussion (Misc queries) 3 June 25th 07 05:08 PM
interactive charts for stacked bar charts [email protected] Charts and Charting in Excel 4 December 28th 06 09:58 PM
Combine Clustered Column Bar charts and Stacked column bar charts Richard Charts and Charting in Excel 1 October 26th 06 02:44 AM
Matching the colors Column Charts and Pie Charts RohanSewgobind Charts and Charting in Excel 3 April 21st 06 09:35 PM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"