| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vert bar chart; want bars only for non-zero Y-values
Hello --
We have categories and category %'s totalling 100%; selected category % values might be 0 in some data sets. Example data set: Category Category % ========= ========== Magazines 5 Newspapers 20 Radio 0 TV 30 Cable 45 Satellite 0 --------- Total 100 In this case, we want vertical bars representing the Category %s for Magazines, Newspapers, TV, and Cable, with these category names as X-axis labels. What is the best way to eliminate from the chart the categories having Category % values = 0? Thanks for any help. L Mehl |
|
#2
|
|||
|
|||
|
L Mehl,
One method would be to apply autofiltering to your data. With your chart data source set up like this you have six X-axis labels with four bars: Magazines 5 Newspapers 20 Radio 0 TV 30 Cable 45 Satellite 0 To get rid of the two axis labels associated with zero values, go to the standard toolbar and hit Data - Filter - AutoFilter. In the Custom Filter Dialog Box choose the option - show rows whe data is greater than 0. All rows with zero values will be filtered out leaving your chart with a source that looks like: Magazines 5 Newspapers 20 TV 30 Cable 45 You should now have four X-axis labels with four bars. ---- Regards, John Mansfield http://www.pdbook.com "L Mehl" wrote: Hello -- We have categories and category %'s totalling 100%; selected category % values might be 0 in some data sets. Example data set: Category Category % ========= ========== Magazines 5 Newspapers 20 Radio 0 TV 30 Cable 45 Satellite 0 --------- Total 100 In this case, we want vertical bars representing the Category %s for Magazines, Newspapers, TV, and Cable, with these category names as X-axis labels. What is the best way to eliminate from the chart the categories having Category % values = 0? Thanks for any help. L Mehl |
|
#3
|
|||
|
|||
|
L Mehl,
This site describes a dynamic option: http://www.pdbook.com/index.php/exce...o_zero_values/ ---- Regards, John Mansfield http://www.pdbook.com "L Mehl" wrote: Hello -- We have categories and category %'s totalling 100%; selected category % values might be 0 in some data sets. Example data set: Category Category % ========= ========== Magazines 5 Newspapers 20 Radio 0 TV 30 Cable 45 Satellite 0 --------- Total 100 In this case, we want vertical bars representing the Category %s for Magazines, Newspapers, TV, and Cable, with these category names as X-axis labels. What is the best way to eliminate from the chart the categories having Category % values = 0? Thanks for any help. L Mehl |
|
#4
|
|||
|
|||
|
John --
Thank you for both methods. I will try the dynamic one first. Larry "John Mansfield" wrote in message ... L Mehl, This site describes a dynamic option: http://www.pdbook.com/index.php/exce...ied_to_zero_va lues/ ---- Regards, John Mansfield http://www.pdbook.com "L Mehl" wrote: Hello -- We have categories and category %'s totalling 100%; selected category % values might be 0 in some data sets. Example data set: Category Category % ========= ========== Magazines 5 Newspapers 20 Radio 0 TV 30 Cable 45 Satellite 0 --------- Total 100 In this case, we want vertical bars representing the Category %s for Magazines, Newspapers, TV, and Cable, with these category names as X-axis labels. What is the best way to eliminate from the chart the categories having Category % values = 0? Thanks for any help. L Mehl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| I get gaps in bar chart when using weekday values only in x-axis | Charts and Charting in Excel | |||
| How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| linked values in a chart | Charts and Charting in Excel | |||
Linear Mode
