Select the cells that contain the labels for the individual data points. Uncheck the default data label, then choose “Value From Cells”. First Add Data Labels, then Format Data Labels. Note: starting with Excel 2013 for Windows, you can use Format Data Labels to add unique names for each dot. If you select the first column (the row names), Excel will use them as the x axis values, converting each name to an integer.
When you go to insert the chart, select just the numbers. If the x positions and colors don’t look right the first time, look for the “Switch Row/Column” button. Line Chart RecipeĮach row will become a separate line in the chart. If the groups and colors don’t look right the first time, look for the “Switch Row/Column” button. The same data structure should work for stacked bars and the other variations in Excel. Rows should be sorted by the numerical column, in descending order, so the bars will all be in size order. Suggestion: try using the same color for all but one slice Bar Chart RecipeĮach row will become a separate bar.
Rows should be sorted by the numerical column, in descending order, so the slices will all be in size order. Pie Chart RecipeĮach row will become a separate slice, each with a separate color. These "recipes" should work reliably, but if you have any trouble, you can always fall back on " Select Data Source" box, which can help you build the chart one axis and one data series at a time. Here is a list of data arrangements that should work well for the individual charts mentioned.
The problem with the second method is that it's not always clear what arrangement of data will be appropriate for each chart. Excel charts can be built either by using the "Select Data Source" box to select data for different parts of the chart or by highlighting a group of cells and using the "Insert Chart" menu.
0 kommentar(er)
