Formatting a Series in Excel 2007:-

It is somewhat strange that there is not a button on the Layout ribbon for the most popular charting element—the Series element.

In order to format the series, you use the Current Selection drop-down on the left side of either the Layout or Format ribbon. Choose the appropriate series from the list to select the series. Click the Format Selection button to access the Format Data Series dialog.

The Series Options category allows you to plot a series on a secondary axis. This is useful if your one data series contains data that is of a different order of magnitude than the other series. For example, you might chart revenue and gross profit percent. By moving the gross profit percent to the Secondary Axis, you can see detail of revenue in millions and gross profit percentages in the 50% range.

Using the remaining categories, you can edit the Marker style for a series, including the marker color, the line color, the line style, shadow, and 3D formatting.