| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminating categories of zero values from X-axix
Hi , I have a range of sales data from 1 - 30 of a month, i will select the
all range while creating chart.What i want when click on the chart it could eliminate the zero value items from the X-axis. Could i have your help on this ? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Eliminating categories of zero values from X-axix
If the data is listed in a column, filter the data using the autofilter or
by making the range into a list (Excel 2003) or a table (2007). The filter hides certain rows, so filter out the zeros. Hidden cells do not appear in charts by default (this can be changed if necessary), so filtering the sheet also filters the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Raiju" wrote in message ... Hi , I have a range of sales data from 1 - 30 of a month, i will select the all range while creating chart.What i want when click on the chart it could eliminate the zero value items from the X-axis. Could i have your help on this ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminating Blank Values | Excel Discussion (Misc queries) | |||
| Eliminating Values from a worksheet | Excel Worksheet Functions | |||
| Eliminating the high 4 values | Excel Worksheet Functions | |||
| Eliminating 0 values when using the Small formula | Excel Worksheet Functions | |||
| how do I get the x-axis to plot values rather than categories in . | Charts and Charting in Excel | |||
Linear Mode
