Interacting with a pivot table in the Excel Web Application.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Pivot Table Data Crunching chapter 8 - The Excel Web App!
Well hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
We're going to save a couple of Pivot tables up to the Excel Web App, but first I want to show you a really cool trick here.
I created this first Pivot table showing revenue by year and month, and I tied it to these two slicers, or I inserted the slicers.
But then, on the same sheet I created a second Pivot table and a Pivot chart, I need this Pivot chart to respond to those same slicers.
So here's how we do that, in Pivot Chart Tools go to the Analyze Tab, you'll have the Insert Slicer, don't choose that, choose Slicer Connections, and say "Hey, I want this Pivot chart to also be tied to Market and Region." And now both the Pivot table and the separate Pivot chart are tied to the same item.
Alright, now I'm going to hide some extra sheets here, hide the sheet with the raw data, and then save this out to the SkyDrive.
So I already did File, Save, and saved to Web, sign into the SkyDrive, and created it out there in a folder called Public Read-Only, 08-PTWebApp.
Alright, so once we know that's been saved, we'll do File, Close, we're going to view this on the SkyDrive, not using Edit in the browser, I just want to be able to see it in the browser.
And even here in the Non-Edit mode, if I would choose a couple of regions from the slicers, you'll see that the other slicer updates, and then as I scroll down the Pivot table updates, and the Pivot chart update.
So all of this is happening in the browser, not in Edit mode, just in View mode, very cool that I can use those slicers, even though I'm only in read-only mode, to update both the Pivot table and the associated Pivot chart.
This Excel Web App, very, very cool feature, you can't create new Pivot tables here, but you create the Pivot table back in Excel 2010 on your desktop, and then upload it, you can create some nice dashboards that will (unclear)...
Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from Mrxcel!
Pivot Table Data Crunching chapter 8 - The Excel Web App!
Well hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
We're going to save a couple of Pivot tables up to the Excel Web App, but first I want to show you a really cool trick here.
I created this first Pivot table showing revenue by year and month, and I tied it to these two slicers, or I inserted the slicers.
But then, on the same sheet I created a second Pivot table and a Pivot chart, I need this Pivot chart to respond to those same slicers.
So here's how we do that, in Pivot Chart Tools go to the Analyze Tab, you'll have the Insert Slicer, don't choose that, choose Slicer Connections, and say "Hey, I want this Pivot chart to also be tied to Market and Region." And now both the Pivot table and the separate Pivot chart are tied to the same item.
Alright, now I'm going to hide some extra sheets here, hide the sheet with the raw data, and then save this out to the SkyDrive.
So I already did File, Save, and saved to Web, sign into the SkyDrive, and created it out there in a folder called Public Read-Only, 08-PTWebApp.
Alright, so once we know that's been saved, we'll do File, Close, we're going to view this on the SkyDrive, not using Edit in the browser, I just want to be able to see it in the browser.
And even here in the Non-Edit mode, if I would choose a couple of regions from the slicers, you'll see that the other slicer updates, and then as I scroll down the Pivot table updates, and the Pivot chart update.
So all of this is happening in the browser, not in Edit mode, just in View mode, very cool that I can use those slicers, even though I'm only in read-only mode, to update both the Pivot table and the associated Pivot chart.
This Excel Web App, very, very cool feature, you can't create new Pivot tables here, but you create the Pivot table back in Excel 2010 on your desktop, and then upload it, you can create some nice dashboards that will (unclear)...
Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from Mrxcel!
