![]() ![]() ![]() NOTE: This will also change the layout of the pivot table on which the chart is based. If you want a chart with columns in different colours, the field layout will have to be changed. ![]() The chart shown below is based on a pivot table that has Order Year and City in the Row area, and Cases in the Value area. When you first insert a pivot chart, all the chart columns will be the same color, if there is only one series. See how to change the chart layout, after you build it. In this example, the chart shows sales data, per city, over two years. From the Chart Tools, Layout tab, Current Selection group, select the Vertical (Value) Axis.After you create a pivot table, you can insert a pivot chart, based on that pivot table.Make sure that the chart is still selected.In the dialog box under Horizontal (Category) Axis Labels, click Edit.From the Design tab, Data group, select Select Data.From the Chart Tools, Layout tab, Current Selection group, select the Horizontal (Category) Axis.Make sure that you select the headings as well as the data before you create your chart. In the Series name box, enter the cell reference for the name of the series or use the mouse to select the cell, click OK.Īrrange your data so that headings are directly above and to the left of the data to be charted.In the dialog box under Legend Entry Series, select the first series and click Edit.In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |