• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Linked data to charts 2007

T

tegzee

New Member
Hi - I need help. When I hide data in my spreadsheet relating to the chart. The chart goes blank, in earlier excel versions it was simple to change the chart settings to allow data to be hidden and still display the chart detail.


Can you tell me how I can do this in 2007 as I am going nuts trying to solve what must be relatively easy step?


Thanks
 
Hi Tegzee,


On the Chart tools, select "Select Data" and click on the "Hidden and Empty Cells" button and select the option you want
 
You must log in or register to reply here.
Back
Top