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

excel

ResolvedVersion 2007

Joyce has attended:
Excel Intermediate course

Excel

hwo to do chart

RE: Excel

Hi Joyce, thanks for your query and welcome to the forum. The link to the dynamic chart I mentioned to you is:

http://chandoo.org/wp/2010/08/31/dynamic-chart-with-check-boxes/

It includes a free spreadsheet download of the chart in action. I hope it proves useful! Good luck in your new job and post any questions here if something arises which you're not familiar with.

All the best,

Anthony

Thu 2 Jun 2011: Automatically marked as resolved.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.