formulas and charts

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Formulas and charts

resolvedResolved · Medium Priority · Version 2003

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.

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:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips


Server loaded in 0.08 secs.