| 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 |
| 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 | |||
Threaded Mode
