sheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sheets

Sheets

resolvedResolved · Low Priority · Version 2007

Joy has attended:
Excel Introduction course
Excel Intermediate course

Sheets

filters on charts

RE: sheets

Hello Joy,

Unless you are using Pivot Charts, you need to filter the data that your Chart is built on in order to display the required data on the chart.

Select the required data and click the Filter icon on the Data ribbon tab in the the Sort & Filter group. Use the Down arrows shown on each column to filter your data, which will then be reflected in the chart based on it.

I hope this helps.

Kind regards,

Ruth

Thu 11 Aug 2011: Automatically marked as resolved.


 

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips


Server loaded in 0.11 secs.