#1
|
|||
|
|||
Removing zero values from bubble chart
Hello together,
does somebody know how to remove zero values from a bubble chart? I took a whole table as data range. Within this table, there are also columns with "O" for X and Y value in it. Therefore, my bubble chart shows several bubbles at (0/0) which are all overlapping each other. Now, I would like to find a solution how to remove those bubbles in (0/0) but unfortunately, I didn't make it to find a solution yet. Does anyone know? Thank you all so much! |
#2
|
|||
|
|||
Replace zero value with "#NA" [e.g. using IF()] - the graph line will have gap then instead going to 0. But I'm not sure about bubble charts, I have used this with line graphs only!
|
Tags |
bubble chart |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA code to set xaxis chart values | MitzDriver | Office | 0 | 11-25-2017 10:58 AM |
Removing Costs from the Gantt Chart printout | Joe.D | Project | 2 | 03-11-2015 02:26 PM |
Removing the Gantt chart from a view | raminraiszadeh | Project | 3 | 02-13-2015 01:24 PM |
Please help with Excel bubble chart | seunao | Excel | 0 | 09-13-2014 11:04 PM |
Word chart with words for y-values? | Computerbum | Office | 0 | 09-19-2011 07:09 PM |