Instead of following the standard marketing techniques, Bill departs the norm to show you what HE has found in Excel 2013 and tells you how you can see it LIVE yourself -- today! http://tinyurl.com/xl13preview
Microsoft has improved the Charting process with Excel 2013. today, In Episode #1621, Bill shows us:
- Recommended Charts
- Combo Charts - New Interface
- Cool Chart Styles in the paintbrush icon
- Charting unsummarized data
- Charting data with extra subtotals using the Filter icon
Oh and a side note; while Bill had promised to show us Chart Labels from Formulas today, he ran out of time in this episode. He will tackle that one in the near future.
And if you want to get a look at Excel 2013 for yourself and take it for a test-drive, for a *Limited Time*, try out Office 2013 Home Premium! Visit http://tinyurl.com/xl13preview . Click the 'Excel logo' at the bottom, then Office 365 Home Premium on the right, then 'Try It' to download a trial for up to five PC's! http://tinyurl.com/xl13preview Get started today!
Learn Excel 2013 from MrExcel Right Here on the "Learn Excel from MrExcel" blog!
Be Sure to visit MrExcel.com for All of your Microsoft Excel needs!
Microsoft has improved the Charting process with Excel 2013. today, In Episode #1621, Bill shows us:
- Recommended Charts
- Combo Charts - New Interface
- Cool Chart Styles in the paintbrush icon
- Charting unsummarized data
- Charting data with extra subtotals using the Filter icon
Oh and a side note; while Bill had promised to show us Chart Labels from Formulas today, he ran out of time in this episode. He will tackle that one in the near future.
And if you want to get a look at Excel 2013 for yourself and take it for a test-drive, for a *Limited Time*, try out Office 2013 Home Premium! Visit http://tinyurl.com/xl13preview . Click the 'Excel logo' at the bottom, then Office 365 Home Premium on the right, then 'Try It' to download a trial for up to five PC's! http://tinyurl.com/xl13preview Get started today!
Learn Excel 2013 from MrExcel Right Here on the "Learn Excel from MrExcel" blog!
Be Sure to visit MrExcel.com for All of your Microsoft Excel needs!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast, episode 1621.
Excel 2013 Charting.
Hey! Yesterday, talked about the new books, I wrote for Excel 2013 charts and graphs, is one of those and the items that are really going to make a difference in your life.
So, today I'm going to cover several of them about charting the first thing that we have, under charting is the new concept of recommended charts, which chart types you should choose?
Well, they're going to suggest, based on the data, and this is good.
This is a time series.
It has 12 points always say with 12 points, you can do a line or column.
They've added an area chart in, okay!
I wouldn't have thought of that, but great.
So, we'll choose one of these click [ ok ].
All right! Now check this out.
We used to have design layout and format layout is completely gone, replaced with a plus icon.
But the icon that I love is the paint brush.
In the paint brush, they have chart styles that actually look good as compared to the old quick layout, which was completely pointless.
All right! And we'll take a look at some of these later, but there is really interesting looking charts, and they didn't do anything new.
All of these were available with the whole tools, you just would have had a thought of the ways to combine them like, that one.
That's a great way to get those data labels up there and so on.
So, I really like the the paintbrush icon.
The other thing that's interesting is here we have a data set.
That's hard to chart, two lines of numbers in thousands in one gross profit percent.
Of course, this requires a combo chart which is normally hard to do.
Well, first off, the recommended chart number one gets it right away.
Oh, hey, we're going to do columns for the revenue and profit.
We're going to do a line for gross profit.
So, they kind of steal my thunder because I really wanted to show you, what happens when I click on all charts and go to combo.
And do well, it'll choose custom.
This new interface is great.
I get to choose, which chart type to use for each series which one to put on the secondary axis.
So, I have absolute control out here.
This is a really really good interface to create that chart title.
All right! next up, here's the data set that clearly cannot be charted 500 rows of detailed data.
Let's throw this at the recommended charts and see what happens.
All right! Any time that the thumbnail has this icon, they're going to summarize things.
So, sum of revenue by region, sum of profit by product, sum of revenue by product and so on.
They are looking at it.
So, it's secret, right.
They're using heuristics to figure out which charts to use.
They're looking for columns that have very few unique items, so in this case, I have three regions and three products.
That are using that over and over and over.
Customers with 26, unique customers never shows up.
But that's okay if I really wanted to report I've revenue by customer, click [ ok ].
See, they actually created a pivot table for me.
I could just unchoose region, choose customer, and I now have that report, very nice.
I don't need to summarize it.
They're going to summarize it for me.
Kind of Impressive, the other one is here's a data set that is not suitable for charting because of the sub totals.
All right! So, we have January, February March, and then here's a total of those three.
Those three months, so that's going to look horrible.
I would normally create a second data set, that has those quarters taken out as the total taken out and try and short that.
Let's just create a chart, insert recommended charts, all right!
They do the same thing here, that looks great.
Now the funnel icon.
The funnel icon is really cool.
I can, using the photo icon say look, I don't want to show cost of goods sold.
We're going to uncheck that.
Also, I don't want to show Q1.
I don't want to show Q2.
I don't want to show Q3.
I don't want to show Q4 or the total and watch, are you seeing the chart?
The chart kind of highlights, or animates as I hover over each one of these.
Get the total out of there, apply.
All right! And now from this data set that has sub totals added in.
I've created a report with just the monthly data without the cost of goods sold data.
And that's from the funnel icon, in Excel 2013.
Now Excel 2013, doesn't come out till Q1.
But you can try it right now for free, go to Tinyurl.com/xl13preview Take a look at where to go once you get there, scroll down to the bottom, click the Excel icon, office 365 home premium and then try it.
Choose your country, register if you're not signed into Microsoft.com and let you download it to 5 PCs.
And you'll be able to try it out for the next month or so.
Hurry up this is December 2012.
It's here now, I'm sure once the product hits the stores the preview will be gone.
So, take some time here over the holidays and give it a try and...
Hey! I want to thank you for stopping by, we’ll see you next time for another netcast, from MrExcel.
Learn Excel from MrExcel podcast, episode 1621.
Excel 2013 Charting.
Hey! Yesterday, talked about the new books, I wrote for Excel 2013 charts and graphs, is one of those and the items that are really going to make a difference in your life.
So, today I'm going to cover several of them about charting the first thing that we have, under charting is the new concept of recommended charts, which chart types you should choose?
Well, they're going to suggest, based on the data, and this is good.
This is a time series.
It has 12 points always say with 12 points, you can do a line or column.
They've added an area chart in, okay!
I wouldn't have thought of that, but great.
So, we'll choose one of these click [ ok ].
All right! Now check this out.
We used to have design layout and format layout is completely gone, replaced with a plus icon.
But the icon that I love is the paint brush.
In the paint brush, they have chart styles that actually look good as compared to the old quick layout, which was completely pointless.
All right! And we'll take a look at some of these later, but there is really interesting looking charts, and they didn't do anything new.
All of these were available with the whole tools, you just would have had a thought of the ways to combine them like, that one.
That's a great way to get those data labels up there and so on.
So, I really like the the paintbrush icon.
The other thing that's interesting is here we have a data set.
That's hard to chart, two lines of numbers in thousands in one gross profit percent.
Of course, this requires a combo chart which is normally hard to do.
Well, first off, the recommended chart number one gets it right away.
Oh, hey, we're going to do columns for the revenue and profit.
We're going to do a line for gross profit.
So, they kind of steal my thunder because I really wanted to show you, what happens when I click on all charts and go to combo.
And do well, it'll choose custom.
This new interface is great.
I get to choose, which chart type to use for each series which one to put on the secondary axis.
So, I have absolute control out here.
This is a really really good interface to create that chart title.
All right! next up, here's the data set that clearly cannot be charted 500 rows of detailed data.
Let's throw this at the recommended charts and see what happens.
All right! Any time that the thumbnail has this icon, they're going to summarize things.
So, sum of revenue by region, sum of profit by product, sum of revenue by product and so on.
They are looking at it.
So, it's secret, right.
They're using heuristics to figure out which charts to use.
They're looking for columns that have very few unique items, so in this case, I have three regions and three products.
That are using that over and over and over.
Customers with 26, unique customers never shows up.
But that's okay if I really wanted to report I've revenue by customer, click [ ok ].
See, they actually created a pivot table for me.
I could just unchoose region, choose customer, and I now have that report, very nice.
I don't need to summarize it.
They're going to summarize it for me.
Kind of Impressive, the other one is here's a data set that is not suitable for charting because of the sub totals.
All right! So, we have January, February March, and then here's a total of those three.
Those three months, so that's going to look horrible.
I would normally create a second data set, that has those quarters taken out as the total taken out and try and short that.
Let's just create a chart, insert recommended charts, all right!
They do the same thing here, that looks great.
Now the funnel icon.
The funnel icon is really cool.
I can, using the photo icon say look, I don't want to show cost of goods sold.
We're going to uncheck that.
Also, I don't want to show Q1.
I don't want to show Q2.
I don't want to show Q3.
I don't want to show Q4 or the total and watch, are you seeing the chart?
The chart kind of highlights, or animates as I hover over each one of these.
Get the total out of there, apply.
All right! And now from this data set that has sub totals added in.
I've created a report with just the monthly data without the cost of goods sold data.
And that's from the funnel icon, in Excel 2013.
Now Excel 2013, doesn't come out till Q1.
But you can try it right now for free, go to Tinyurl.com/xl13preview Take a look at where to go once you get there, scroll down to the bottom, click the Excel icon, office 365 home premium and then try it.
Choose your country, register if you're not signed into Microsoft.com and let you download it to 5 PCs.
And you'll be able to try it out for the next month or so.
Hurry up this is December 2012.
It's here now, I'm sure once the product hits the stores the preview will be gone.
So, take some time here over the holidays and give it a try and...
Hey! I want to thank you for stopping by, we’ll see you next time for another netcast, from MrExcel.
