1 Chart - Different series format

**chrisabberton** · 07-28-2005, 06:46 AM

I presently have an XY line chart showing asset price over time. Pretty simple.

X Axis - Time Scale
Y Axis - Asset Price

I would now like to add an additoinal series showing the volume of assets traded, ideally this would be as a bar chart sitting "underneath" the asset price on the chart. They would share the same X Axis.

I have added another series, but this simply displays the volume traded as another line, and even when this is set to a secondary axis the scaling makes this unworkable. i have adjusted the scales of both, still this does not make it workable, i want the series as a bar chart instead.

Is this possible ?

Edit - That should read column chart, as i want the bars to be verticle.

Andy Pope · 07-28-2005, 08:05 AM

Hi,

Have you selected the volume data series, right clicked and changed the
chart type to Columns?

Cheers
Andy

chrisabberton wrote:
> I presently have an XY line chart showing asset price over time. Pretty
> simple.
>
> X Axis - Time Scale
> Y Axis - Asset Price
>
> I would now like to add an additoinal series showing the volume of
> assets traded, ideally this would be as a bar chart sitting
> "underneath" the asset price on the chart. They would share the same X
> Axis.
>
> I have added another series, but this simply displays the volume traded
> as another line, and even when this is set to a secondary axis the
> scaling makes this unworkable. i have adjusted the scales of both,
> still this does not make it workable, i want the series as a bar chart
> instead.
>
> Is this possible ?
>
>
> Edit - That should read column chart, as i want the bars to be
> verticle.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info