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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas and charts

Formulas and charts

ResolvedVersion 2003

Thu 11 Sep 2008, 16:18 Delegate Byron said...

Byron has attended:
Word Advanced course
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Outlook Introduction course
Outlook Advanced course

Formulas and charts

How can I set up a what if statement that refences a drop down box so that when I click on a month the chart changes. An simple what if example would be great as I remember doing this at school but am a bit sketchy.

Fri 12 Sep 2008, 10:46 Trainer Amanda said...

RE: Formulas and charts

Hi Byron

Thank you for your post.

Would it be suitable to create a pivot chart of your data - that way you can change the month and the data relating to the month you have chosen will show in the chart?

Kind regards
Amanda

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Formulas and charts

Formulas and charts

RE: Formulas and charts

Excel articles

Excel tip:

Selecting constant values only