Plot Visible Data in Excel 2010


Andy Roberts

I have grouped columns which are hidden and charts based on those columns
don't display the data. I can change this for each chart using the design
gtab on the ribbon under the Select Data Option but this is on a chart by
chart basis.

In previous versions of Excel you could control this generically thought
Tools > Options. Can I set this generically in 2010 or do I have to do it
for each chart?


Win XP Pro
Office 2010


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