Powerpoint chart legend not updating datingol ru

09-Jan-2020 03:31

The min and max X for the XY chart’s X axis are entered in B11 and B12 (these are Excel’s automatic scale limits in the XY chart above).To provide reasonable resolution, we’ll scale the area chart’s X data from 0 to 1000.To fill under or between XY series, we’ll make use of this same approach: XY data on primary axes, Area data on secondary axes, with a secondary date axis.Let’s start with the simple case of filling color below an XY plot.Shading between plotted lines with a light color can enhance some charts.

Recently in Shaded Quadrant Background for Excel XY Scatter Chart I showed how to generate a background grid of colored rectangles.

It takes up space, but I’ll leave the legend there until the end to help us keep track of which series is which.

The formulas to calculate the area chart X and Y values are like those used in the simpler example above.

The new data is added as additional XY series, which is fine.

Select one of the Area data series (still plotted as XY), press Ctrl 1 to open the Format Series Task Pane or Dialog, and choose Secondary Axis.

Recently in Shaded Quadrant Background for Excel XY Scatter Chart I showed how to generate a background grid of colored rectangles.

It takes up space, but I’ll leave the legend there until the end to help us keep track of which series is which.

The formulas to calculate the area chart X and Y values are like those used in the simpler example above.

The new data is added as additional XY series, which is fine.

Select one of the Area data series (still plotted as XY), press Ctrl 1 to open the Format Series Task Pane or Dialog, and choose Secondary Axis.

Simple data, simple chart of type Scatter With Straight Lines and Markers.