Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas and charts
Resolved · 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
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.
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 fontYou can change the default font and font size for all spreadsheets created in Excel by: |
We'll call during UK business hours
Server loaded in 0.08 secs.