1 Chart - Different series format

C

chrisabberton

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.
 
A

Andy Pope

Hi,

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

Cheers
Andy
 
C

chrisabberton

Andy, thanks.

That was embarrassingly easy, i don't know why but i assumed that woul
change the format of the whole graph.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top