Add new data to an existing chart. Learn two easy ways.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Settle in-depth Chapter 32; Expanding Charts Hey, welcome back to the MrExcel netcast. I'm Bill Jelen, talking about charts in Chapter 32.
Here's one of my favorite tricks.
So, I used to have to create a dozen charts at the company I worked for every month and so, be the first of the month that I had to go back and recreate all the charts.
It just took me a whole day to do it.
If I would have known this next trick, my life would have been so much simpler.
Here I have a chart with data for January through March, and I have a new data point April. So I'm going to choose the heading and the data.
Really important that you choose the heading and we're going to copy.
So that's Ctrl+C and then I click on the chart, and I press Ctrl+B.
Ctrl+B, it takes my existing chart as the new data to the right hand side.
I like the Copy and Paste method.
Because it works even if the chart is on a different worksheet, than the data you can copy and paste.
Now, if your data and chart do happen to be in the same spot, first click on the chart, look at that blue outline right there, that blue outline shows the data that's in the chart, to add new data the right hand side and grab that blue outline, drag to the right and the new data gets added.
Those blue outlines are pretty cool, actually, you can use it to take data of the left side or even to change which data is charted, so, if I wanted to show just Sales.
There's just Sales or just Profit you know that, using those blue outlines, a pretty cool method there.
The new method, sort of new method is using tables in Excel.
So we press, choose our data make sure to have a heading up there and anyone press Ctrl+T and we define that as a table.
So now the chart is based on the table and then, when we add a new month, it will automatically become part of the data... part of the chart, So, a very interesting way to go there.
Then Ctrl+T to show the, convert the data to a table and any charts and pivot tables that are based on that pivot table will automatically grow.
All right, so don't create your charts time after time after time.
Just use last month's chart.
Put the new data next to the old data and then use one of these three methods to get there through chart.
Hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Settle in-depth Chapter 32; Expanding Charts Hey, welcome back to the MrExcel netcast. I'm Bill Jelen, talking about charts in Chapter 32.
Here's one of my favorite tricks.
So, I used to have to create a dozen charts at the company I worked for every month and so, be the first of the month that I had to go back and recreate all the charts.
It just took me a whole day to do it.
If I would have known this next trick, my life would have been so much simpler.
Here I have a chart with data for January through March, and I have a new data point April. So I'm going to choose the heading and the data.
Really important that you choose the heading and we're going to copy.
So that's Ctrl+C and then I click on the chart, and I press Ctrl+B.
Ctrl+B, it takes my existing chart as the new data to the right hand side.
I like the Copy and Paste method.
Because it works even if the chart is on a different worksheet, than the data you can copy and paste.
Now, if your data and chart do happen to be in the same spot, first click on the chart, look at that blue outline right there, that blue outline shows the data that's in the chart, to add new data the right hand side and grab that blue outline, drag to the right and the new data gets added.
Those blue outlines are pretty cool, actually, you can use it to take data of the left side or even to change which data is charted, so, if I wanted to show just Sales.
There's just Sales or just Profit you know that, using those blue outlines, a pretty cool method there.
The new method, sort of new method is using tables in Excel.
So we press, choose our data make sure to have a heading up there and anyone press Ctrl+T and we define that as a table.
So now the chart is based on the table and then, when we add a new month, it will automatically become part of the data... part of the chart, So, a very interesting way to go there.
Then Ctrl+T to show the, convert the data to a table and any charts and pivot tables that are based on that pivot table will automatically grow.
All right, so don't create your charts time after time after time.
Just use last month's chart.
Put the new data next to the old data and then use one of these three methods to get there through chart.
Hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
