Excel Chart Change Data How To Decorate A

Excel Chart Change Data How To Decorate A

You also find out how to decorate a chart with a picture, display worksheet data alongside a chart, and place a trendline on a chart.

If you have a picture in your computer that would serve well to decorate a chart, you are hereby encouraged to start decorating.

While the picture is still selected, experiment by dragging the Transparency slider on the Format tab.

If yours is a simple pie chart or other chart that wasnt generated with a large amount of raw data, you can display the data alongside your chart in a data table.

Anyone who sees the table knows youre not kidding or fudging the numbers.

You see the Format Data Table dialog box, where you can fill the table with color and choose colors for the lines in the table.

Viewers can see, for example, that sales are going up or down, income is rising or falling, or annual rainfall is increasing or decreasing.

In the Format Trendline dialog box, choose a line color and line style.

Excel For Mac Chart Change Data