Best Display Two Different Data Series In Excel Chart

In this case is Revenues much bigger than No.

Display two different data series in excel chart. Right-click the chart and then choose Select Data. Start by creating a chart with just one axis. Next click on the column in the chart which contains the values for the line chart.

Separating data into different series for display in a chart - excel 2003 I have multiple groups of data organized by location and ethnicity. The current article describes a special case of this in which the X values are dates. From the Format tab Current Selection Group check you have the correct data series selected and then click Format Selection.

Right-click on the chart and select Change Series Chart Type. July 7 2014 at 158 pm. Step 2 use Secondary Axis.

Go to the. On the Data Labels tab choose Series Name and press OK. Right click on the data series again and click on Format Data Series.

Create the Time Series A line chart above left copy the Time Series B data select the chart and use Paste Special to add the data as a new series using the options as shown. Textbox then click OK. Joe Miyaki email protected Reply.

Then double click on the point or press CTRL1 numeral one to open the Format Point dialog. This makes it easier to build out columns for each category. Time series A has weekly data but with two values omitted.