Plot Visible Data in Excel 2010

A

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?

Regards

Andy
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

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Looking to flip text in Excel file (2010) 0
Create a chart from a table in word thats dynamic 0
Uninstalling H&S 2010 after installing 2019 3
Cell data entering slow! 0
Is ExecuteExcel4Macro still works in Excel 2013 or later version? 1
Creating a Chart on form from selected data in query. 0
Excel 2013 Copying pivot charts to PowerPoint 0

Top