- HOW TO CHANGE LEGEND NAME IN EXCEL PIVOT CHART HOW TO
- HOW TO CHANGE LEGEND NAME IN EXCEL PIVOT CHART DOWNLOAD
Next, you can format the formula cell to make it bold font, and a bigger size.
Otherwise, show the selected Region name, from cell C2. Or, if cell C2 contains “(Multiple Items)”, the result ends with “Multiple Regions”. Then, if cell C2 contains “(All)”, the result ends with “All Regions”. That formula starts with the text string =”Annual Sales - ” IF(C2=”(Multiple Items)”,”Multiple Regions”,C2)) The formula can’t go directly into the chart title, so we’ll build it on the worksheet, then link to the formula cell.Įnter the following formula in cell G2 (I’ve added line breaks, so it’s easier to read): To check for those 3 Report Filter options, we’ll build a nested IF formula. (Multiple Items) – show “Multiple Regions”. Region Name – show the selected Region name. We want the chart title to say “Annual Sales - “, followed by information from the Report Filter cell, C2.īased on the value in cell C2, this text should appear in the pivot chart title: That will help us build a dynamic title, to show details on what was selected in the Region filter. Instead of typing a new chart title in the Title box, we’ll create a chart title formula, in a cell on the worksheet. (Multiple Items) – if 2 or more Regions were selected, but not all Regions. Region Name – if a single Region was selected. (All) – if no filter has been applied yet, or if (All) was selected. The “Select Multiple Items” option is turned on, so you can select one or more of the regions.īased on the selection in the Report Filter, cell C2 will show one of these results: There are four regions in the food sales data – East, West, Central and South. 
Drag the chart title up, to position it in the blank space above the plot area. Then, click Chart Title, and click the “Centered Overlay” option – that adds a title, without making the plot area smallerĪ generic title is added to the pivot chart, with the text “Chart Title”. With the pivot chart selected, click the Design tab on the Excel Ribbon. There’s no title on the chart, so follow these steps to add a title: Click OK, to accept the recommended chart layout – a Clustered Column chart.Ī pivot chart is added to the worksheet, showing the 2 years of data. In the Charts group, click Recommended Charts. On the Excel Ribbon, click the Insert tab. To create a pivot chart from the food sales pivot table, follow these steps: The video timeline, and written instructions, are below the video. To see the steps for creating a dynamic Pivot Chart title, watch this video. You can delete those, and build your own. The sample file contains the completed formula and pivot chart. HOW TO CHANGE LEGEND NAME IN EXCEL PIVOT CHART DOWNLOAD
NOTE: To follow along with this tutorial, go to the Pivot Chart page on my Contextures blog, and download the sample file. You can select a region name from the drop down list, and the pivot table shows the sales in that region. The pivot table shows quantity sold over 2 years, in each food category. In this example, there is a pivot table with one field, Region, in the Report Filter area.
HOW TO CHANGE LEGEND NAME IN EXCEL PIVOT CHART HOW TO
See how to create a formula on a worksheet, then link to that cell, to create a pivot chart title from a report filter cell. Instead of typing a pivot chart title, which never changes, use this method to create a dynamic heading.
0 kommentar(er)
