| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting 3-D Graphs with Empty Cells
I am making a 3D graph and my data include empty cells. As a result the
graph drops off and doesnt look right. Does anyone know of any quick fix so excel doesnt use that data in the graph? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting 3-D Graphs with Empty Cells
Don't select the empty cells. Select the first group of data cells and then
use the Control key to select the second group of data cells, etc. Using Control when you click to select will add the second group to the first group and will skip the blank ones in between. wrote in message oups.com... I am making a 3D graph and my data include empty cells. As a result the graph drops off and doesnt look right. Does anyone know of any quick fix so excel doesnt use that data in the graph? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting 3-D Graphs with Empty Cells
Hi,
Which of the 3d graph type are you using? Is the cell really empty, it doesn't contain a formula? Cheers Andy wrote: I am making a 3D graph and my data include empty cells. As a result the graph drops off and doesnt look right. Does anyone know of any quick fix so excel doesnt use that data in the graph? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
| Ignoring empty cells | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| Eliminate empty cells in data range | Excel Discussion (Misc queries) | |||
| Trendlines to ignore empty cells | Charts and Charting in Excel | |||
Linear Mode
