B

#### Bruce

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