Chart Blanks Out When I hide data column

J

JMay

I have a great chart on my worksheet, but when I hide the Column
of data that makes your it's data the Chart Goes BLANK.

What must I do to be able to hide the column YET have the data
reflected in the CHART?

TIA,
 
S

Shane Devenshire

Hi,

Select the chart, and choose Tools, Options, Chart tab, and make sure Plot
visible cells only is not checked.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

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

Need Help with a VBA subroutine 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Code to Hide Rows 8
Chart Help 1
Zeros Display On Chart 0
Stacked Bar Chart 1
Pivot Chart Trendline? 0
How I can set dynamic pivot table ONLY when I have enough data point 1

Top