I've made a Pivot Table / Chart in Excel on Windows 10. See screenshot below. I've sent the Excel document to a person who opened it on a Mac (see photo below). When she opens the file on the Mac, there are no filtering buttons on the bottom of the chart and there are no filtering fields on the right side of the worksheet (even though you can see them on Windows). Is this a limitation of using Excel on the Mac? Or is it some setting that needs to be fixed? Something else?
Thanks for any insight.
Learn how to create a column chart that displays the percentage change between each column. This is an Excel chart that uses error bars and some formulas to show the variance between each time period (month, quarter, year, etc.) Download the Excel file: This chart was inspired by a chart in an article on music industry trends from Visual Capitalist: I've also published another video with a 2nd iteration that includes color bars & data labels (conditional formatting), slicers, and is more dynamic. Here is a link to that video.
Part 2: Part 3: One request we almost always get with our column or bar charts is to see the variance or percentage change between each column. This is especially true when the chart displays a trend over months, quarters, years, etc. The solution uses a regular clustered column chart in Excel. The second series is made invisible with No Fill on the column, and then uses error bars to display the variance between amount columns.Excel 2010 & Earlier. If you are using Excel 2010 or earlier you will not have the Value from Cells option for the data labels. However, you can use the free XY Labeler add-in from AppsPro to create the labels. This will save you a lot of time.
This wikiHow teaches you how to add fields as columns to a PivotTable in Microsoft Excel using the PivotTable tools, as well as how to add a calculated field to a PivotTable. Click on the PivotTable. This will open the Field List.
Here is the link to download the add-in. Related articles & videos: Part 2 with colored error bars & labels: Variance on Clustered Column for Actual versus Budget: 3-part Video Series on Pivot Tables & Dashboards: Free Chart Alignment Add-in.