Hi Dave,
To bring the smaller data set to the front in an area chart in Excel 2007, you can follow these steps:
- Select the chart by clicking on it.
- Click on the "Format" tab in the "Chart Tools" section of the ribbon.
- In the "Current Selection" group, click on the drop-down menu and select the smaller data set that you want to bring to the front.
- Right-click on the selected data set and choose "Format Data Series" from the context menu.
- In the "Format Data Series" dialog box, click on the "Series Options" tab.
- Under "Plot Series On", select "Primary Axis" if it is not already selected.
- Under "Series Overlap", increase the value to move the smaller data set in front of the larger one. You can experiment with different values until you get the desired result.
- Click "Close" to close the dialog box.
Your smaller data set should now be visible in front of the larger one in the area chart.