|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-14-2008, 04:32 PM
|
|||
|
|||
|
Fixing Charts
Hello
I do not want my chart to show when a value is zero. For example, say the following is my data: Apples Bananas 0 5 0 3 1 12 5 90 If I chart these both as series, I want it to show [i]only[i] the values, and not the zeros on the chart. Any ideas? Thanks! 
|
|
#2
08-15-2008, 06:31 AM
|
||||
|
||||
|
Charts will not automatically exclude zero data points.
You have to either use auto filter to hide rows not required in chart, making sure chart has option to display visible cells only. Or create dedicated chart data that excludes the zero items.
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
