I’ll move it and apply the same dark style from the Chart Styles gallery. I’ll mark the sales results again, click the “INSERT” tab and “Recommended Charts”. Now I want to insert another chart showing sales contribution by region. To close down the chart tools click anywhere outside the chart area. Finally I’ll mark the title and write”2014 Total Sales by Region”. Then I’ll click the arrow next to the “Axes” and uncheck the “Primary vertical axis”. I want to add the sales results on top of each column so I’ll click the first button and mark the “Data Label” check box. The first button gives you options to modify the chart elements, the second button the style and the color of your chart and the third the data selection. You can easily make modifications to your chart using one of the three buttons that now appear next to your chart. I’ll select this dark design which provides better contrast. Under the “DESIGN” tab, in the Chart Styles Gallery you get a live preview of what your chart will look like with different designs. To modify a chart, mark the chart so that the Chart Tools appear. In Excel 2013 Microsoft has cleaned up the Chart tools so that they are easier to use. Modifying charts with the simplified Chart Tools (01:40) I’ll move the chart by holding down the left mouse button and dragging it to the desired position. In this case I prefer the first column chart so I’ll click OK to insert it into my spreadsheet. You can click through the various recommended charts to see which one you prefer. Excel will analyze your selected data and recommend the best possible chart to visualize it for you. Click the “INSERT” tab, instead of manually selecting one of the many charts available in the Charts section click “Recommended Charts”. In general it’s better not to include totals since the details might be hard do see. To add a recommended chart, mark the data you want to include in the chart. In Excel 2013 it’s much easier to select charts, since Excel provides you with recommendations. First I want to add a chart that shows only the sales by region. On this first worksheet I have a table showing sales and forecasted sales by region 2014. To make this report more visual I am going to add charts.
Here I have a sales report showing sales for 2014. Visualizing data with Recommended Charts (00:32) In this video you will learn how to use charts to spot trends and you will learn how to use the updated charting tools to make your graphs really stand out. In this version of Excel it is much easier to select appropriate charts since Excel analyzes your data and recommends charts for you. If you have a lot of numbers in your spreadsheet it really helps to visualize your data using charts.
0 kommentar(er)
