Say that you need to show a rolling 6 month chart. Usually, I show how to drag the blue outline around the source data. However, in todays podcast, Kirk offers an alternative tip include all of the columns in your chart and hide/unhide the columns that you want to appear in your chart. Episode 590 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today I have a cool tip to show on charting.
This is a tip I picked up in one of my power Excel seminars, fellow named Kirk, from row 2 gave me the great idea.
I want to thank Kirk for passing that along.
One tip that I show and it's already in my book is how to change the data that's in a chart.
So, if we need to show rolling six months where the data, here we have a chart that shows January through June.
When I click on the chart I get a blue outline around the data and I can grab the border of that blue outline and just move it.
So, if I move it to the right, a couple of columns the chart now changes to show May through August.
Well, Kirk's solution was a little bit different.
He said hey, just go ahead and chart all of the data and show all 12 months.
I mean then basically move your chart out of the way, I'll move it over here to the right hand side and he said then if you want to show just six months, hide the column.
So, if we hide January, February, March Format, Column, Hide and then October, November, December.
The chart automatically updates to show just the visible columns, that's a cool trick.
I guess it's been there forever something I never knew.
So, it turns out that if you want to customize which months or data points are in a chart.
You can hide the columns that you don't want in the chart, and the chart will automatically update to show just the visible columns.
Hey, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Today I have a cool tip to show on charting.
This is a tip I picked up in one of my power Excel seminars, fellow named Kirk, from row 2 gave me the great idea.
I want to thank Kirk for passing that along.
One tip that I show and it's already in my book is how to change the data that's in a chart.
So, if we need to show rolling six months where the data, here we have a chart that shows January through June.
When I click on the chart I get a blue outline around the data and I can grab the border of that blue outline and just move it.
So, if I move it to the right, a couple of columns the chart now changes to show May through August.
Well, Kirk's solution was a little bit different.
He said hey, just go ahead and chart all of the data and show all 12 months.
I mean then basically move your chart out of the way, I'll move it over here to the right hand side and he said then if you want to show just six months, hide the column.
So, if we hide January, February, March Format, Column, Hide and then October, November, December.
The chart automatically updates to show just the visible columns, that's a cool trick.
I guess it's been there forever something I never knew.
So, it turns out that if you want to customize which months or data points are in a chart.
You can hide the columns that you don't want in the chart, and the chart will automatically update to show just the visible columns.
Hey, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
