software

Hello
I am trying to plot 2 sets of data on one graph by using both a primary and
secondary axes. Both sets of data need to be in a column format. The only
option I can find in quot;chart wizardquot; is a line and column on 2 axes.

Does anyone know if I can plot the data in 2 columns with no lines?

Hi,

Just create a standard column chart. Double click the series you want
to be on the secondary axis and use the format dialog to place it there.

With column charts the default will be for the secondary axis columns to
sit right in front of the primary axis columns so you will need to add
some dummy data. See here for instructions.
peltiertech.com/Excel/Charts/...OnTwoAxes.html

Cheers
Andy

A wrote:
gt; Hello
gt; I am trying to plot 2 sets of data on one graph by using both a primary and
gt; secondary axes. Both sets of data need to be in a column format. The only
gt; option I can find in quot;chart wizardquot; is a line and column on 2 axes.
gt;
gt; Does anyone know if I can plot the data in 2 columns with no lines?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Thanks Andy. Much appreciated.

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Just create a standard column chart. Double click the series you want
gt; to be on the secondary axis and use the format dialog to place it there.
gt;
gt; With column charts the default will be for the secondary axis columns to
gt; sit right in front of the primary axis columns so you will need to add
gt; some dummy data. See here for instructions.
gt; peltiertech.com/Excel/Charts/...OnTwoAxes.html
gt;
gt; Cheers
gt; Andy
gt;
gt; A wrote:
gt; gt; Hello
gt; gt; I am trying to plot 2 sets of data on one graph by using both a primary and
gt; gt; secondary axes. Both sets of data need to be in a column format. The only
gt; gt; option I can find in quot;chart wizardquot; is a line and column on 2 axes.
gt; gt;
gt; gt; Does anyone know if I can plot the data in 2 columns with no lines?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;