• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Create A Self Expanding Chart In Excel

Create A Self Expanding Chart In Excel

September 23, 2020 by Barbara

Hello Excellers, welcome back to another Excel tip today. I will show you how to create a self-expanding chart. This tip is also a YouTube Video. Why not check it out in the link below. So, it is really easy to create a self-expanding chart in Excel. Is it?. YES!. Normally a chart is set up to only display what is currently on the datasheet. But, by a few tweaks and Excel magic, we can set up a chart differently. We can allow a chart to automatically accommodate new data as it is added.

So, in Excel 2007 we can use a new table feature if you need the workbook to be backward compatible with previous Excel 2003 versions you need to do a few more clicks to get the same result. Let’s look at Excel 2007 and Excel 2003 first.

Create A Self Expanding Chart.

To create your self expanding chart in Excel 2007 and Excel 2003 do the following

  1. Create your chart as usual ( you can use the sample data below)
  2. Select any cell in the range that contains data that is used by the chart
  3. Choose Insert- Tables Tables to convert the range to a table

self expanding chart in Excel Pin it! Share on Facebook

Note, if you are using Excel 2003 in Step 3 above choose Data- List-Create List.

Believe it or not, that’s all there is to it!!. Excel recognises the data as a table and that any data that is added to it, is automatically updated in the chart.

So, as you can see in the screenshot above Northern has been added in automatically after I typed it then tabbed along to the Widget Sales ready for the figure to be entered. A great way to create a self-expanding chart in Excel.

Finally, give this charting technique a go, it a good one to have in your Excel magic box of tricks.

So, if you want more Excel and VBA tips then sign up for my Monthly Newsletter. I share 3 Tips on the first Wednesday of the month. You will receive my free Ebook, 30 Excel Tips and check out all of my Macro Monday posts below.

Want To Watch The Video?

Excel Macro
This image has an empty alt attribute; its file name is Excel-Rescue.png

Filed Under: Blog, Excel Charting Tagged With: Excel Charting, Excel Tips

Comments

  1. Girish SV says

    October 27, 2016 at 4:42 am

    Fantastic and it worked and yet so simple…..Thanks a ton

    • Barbara says

      October 27, 2016 at 8:37 pm

      You are welcome!

      Regards
      Barbara

Trackbacks

  1. Number Rows In An Excel Table says:
    August 30, 2011 at 7:48 pm

    […] 1. Create a self expanding chart […]

  2. Show Zero Values In A Pivot Table says:
    January 13, 2012 at 4:51 pm

    […] 3. Create A self expanding chart in Excel […]

  3. MS Excel Tutorial- What Is A Pivot Table? And How To Create Your First One. says:
    January 29, 2012 at 4:06 pm

    […] 4. Create A Self Expanding Chart In Excel Filed Under: Excel Tips& Tricks, Tutorials Tagged With: Excel Charting, Excel Tips, Worksheets […]

  4. Shorten Y Axis Labels On A Chart says:
    February 13, 2012 at 1:03 pm

    […] 1. Create A Self ExpandingChart In Excel […]

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

Popular Pages

  • Home

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

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Follow Us

  • Twitter
  • Facebook

Search

© howtoexcelatexcel.com. All rights reserved.

  • Privacy Policy