Hi,

I have some stock market data that I is downloaded and in a fixed format but
am having trouble plotting in the dersired manner.

The aim is to plot price on the x axis and volume on the y axis, the twist
is there is a set of data for the bid and a set for the ask price.

The raw data
a) The bid price is in column D
b) The bid volume is in column C
c) The ask price is in column G
d) The ask volume is in column F

The chart
a) The values in the bid price and ask price (col D and G) need to be
combined to make a series for the x axis of the chart as the range overlaps.
b) The bid volume and ask volume are plotted as 2 dependant variables on the
y axis on the same primary axis.

I think the answer is to consolidate the data from 4 columns into 3 where
the 2 price fields are combined. I then know how to plot this as a chart. I
have tried with a pivot table but cant get it right.

Any tips appreciated.

Bassmann