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.In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit.Make sure that you select the headings as well as the data before you create your chart. There should be no blank rows or columns. We've gone for a dark orange colour, but select any colour you like.264How can I make an Excel chart refer to column or row headings?Īrrange your data so that headings are directly above and to the left of the data to be charted. Now click the colour picker, and choose a new colour for the segment: There are quite a lot of options to experiment with.
In Excel 2007, click on Fill from the options on the left. Select Solid fill, and select a colour from the dropdown list: You'll see a panel appear on the right of your screen in Excel 20.Ĭlick the paint bucket icon at the top, then click to expand the Fill option. You should see the following dialogue box appears in Excel 2007: Now right click your segment and, from the menu that appears, select Format Data Point: You should see round circles surrounding just that segment. In the image above, only the 10.99 segment is selected. It's a little bit tricky, but if you do it right your pie chart should look like this: Now left click on one of the segments to select just that individual slice. It is selected when you can see those round handles. Left click on the pie chart itself to select it: Change the Colour of a Pie Chart Segement You can change the colour of each slice of your pie chart, and even move a slice. From the previous lesson, your Pie Chart segements look like this:
0 kommentar(er)
