Charting 3-D Graphs with Empty Cells

I

ianadelson3

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?
 
B

BK

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.
 
A

Andy Pope

Hi,

Which of the 3d graph type are you using?
Is the cell really empty, it doesn't contain a formula?

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overlay line graph points on bar graph 1
Graph Line Width ? 1
surface chart 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Excel 2007 charts: want to avoid zero values 1
Suppres Zero or empty Cell value in a line graph 1
Totals in the data table but not in the graph / chart 1
X-Axis Date 3

Top