Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Consolidate my data and plot on a dual axis chart
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colour plot area of a dual axis x,y chart | Charts and Charting in Excel | |||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlapping ba | Charts and Charting in Excel | |||
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed | Charts and Charting in Excel | |||
Dual x-axis chart | Charts and Charting in Excel | |||
Chart with dual Y axis data | Excel Worksheet Functions |