This will make sure that both axis have the same scale. Type the same values from step 13 into the boxes next to manual. Change the first three settings from Auto to Manual. Make six changes in the Format dialog box. Make a note of the settings in those three boxes. In the Format dialog, change the first three settings from Auto to Fixed. The remaining steps assume the Format dialog box is still open.
MAKE TWO COLUMNS IN POWERPOINT FOR MAC SERIES
Here, the two blank series are moving Series 2 to the right.If you entered 100 and 200 in those series, you would see how they are pushing Series 2 over to the right of the stacked column. You really don't need to show the secondary axis once you make them have the same scale.īy the way, those two extra blank series are there to move Series 2 to the right.There are two extra entries in the legend.The stacked column is wider than the clustered column.The left vertical axis is using a different scale than the first.This changes all three of the series that use the secondary axis.Īt this point, you finally have something that looks almost correct. Choose the first column chart, known as a Clustered Column Chart. Go back to the dropdown and choose Series 2.Go back to the dropdown and choose Series Blank 2.In the Format dialog box, choose Secondary Axis.Go back to the dropdown and choose Series Blank 1.Click Format Selection to open the Format Dialog box.Use the leftmost dropdown to choose Series 2. Click the Switch Row/Column icon to move the Series 1a, Series 1b, and so on to the legend. If you are plotting quarters, Excel will put the wrong data along the horizontal axis.Create a stacked column chart from all five series.Add two blank series between Series 1b and Series 2.Strategy: This chart uses two rogue series and a hidden secondary axis. Problem: I need to create two stacked columns clustered with a third column.
0 kommentar(er)
