Hidden and Empty Cell Settings

K

Karl K.

I have blank cells in an Excel graph. I would like to treat them as "Gaps"
instead of "Zero". However, this option (along with the "Connect data points
with line" option) is grayed out in the Hidden and Empty Cell Settings box.
 

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

surface chart 1
Dealing with the error: unable to filter on excel hc home school 0
charting missing data (empty cells bug) 2
Suppres Zero or empty Cell value in a line graph 1
How do you make a hole in a line graph? 2
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
"treat empty cells as" is greyed out in charts 1
Display empty cells as gaps, zero, or connect in chart 1

Top