• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Create A Very Simple Dynamic Chart Quickly In Excel

Create A Very Simple Dynamic Chart Quickly In Excel

July 26, 2011 by Barbara

There are many ways to create dynamic charts in Excel, but today I want to share with you one of the most simple. In fact I think it is THE simplest way I think I know to create fun simple but impressive dynamic charts.

Let’s for an example say we want to show sales figures for widgets for three months .

  1. First of all create a data set with some sales figures. Use the download the example template at the end of the post if you want to.
  2. Create three standard bar charts one for each month.
  3. Name three corresponding cells with your month names
  4. Change the cell heights in each of the cells- this is where your graphs will sit.
  5. Next put a simple filter on your cells to show your months sales.

Pin it! Share on Facebook

Click away on the filter, sit back and enjoy!!!

Pin it! Share on Facebook

There you have it a really fun, quick simple way to create a stunning interactive dynamic graph in Excel.

Go ahead and give it a go impress your colleagues.

Download the template and example workbook right here.{filelink=2}

You may also like these posts on Excel Charting.

1. Create a self expanding chart in Excel

2. One Click Super Quick Charting

How do you rate this technique for creating dynamic graphs compared to the alternatives using the Index()function?.

Filed Under: Excel Charting

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Search



More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song



Popular Pages

  • Home
  • Privacy Policy

© howtoexcelatexcel.com. All rights reserved.