Microsoft Office Tutorials and References
In Depth Information
Showing a Trend of Monthly Sales and Year-to-Date Sales
The size of the YTD bars
obscures the detail of the
2. In the Format Data Series dialog, select Secondary Axis in the Plot Series On section
of the Series Options page. Click Close. Excel creates a confusing chart, where the
YTD numbers appear directly on top of the monthly numbers, obscuring any monthly
numbers beyond August.
3. Excel deselects the series when you change the chart type. Reselect the YTD series by
clicking the YTD line.
4. On the Format dialog, select Shape Outline, Black to change the YTD line to black.
5. From the Layout tab, turn off the gridlines by selecting Gridlines, None.
6. From the Layout tab, select Axes, Primary Vertical Axis, Show Axis in Thousands.
7. From the Layout tab, select Axis Titles, Primary Vertical Axis Title, Rotated Title.
Type Monthly Sales and press Enter.
8. From the Layout tab, select Axis Titles, Secondary Vertical Axis Title, Rotated Title.
Type YTD and press Enter.
9. Right-click the numbers on the secondary vertical axis. Select Format Axis. In the
Scaling section, select 100,000.
10. Click the legend and drag it to appear in the upper-left corner of the plot area.
11. Click the plot area to select it. Drag one of the resizing handles on the right side of the
plot area to drag it right to fill the space that used to be occupied by the title.