Replies to post #52 on AIM UK

[ls7550]

Steve (The Grabber) showed me a trick you can do with Excel to get the same sort of effect, but its a bit awkward

Say you have price data as below, a buy at 12 and a sell at 15 - then add two more data series with the marker values a positive number at what level you want the + or - markers to show and set all others unmarked rows as a negative number.

Price Buy Sell
12 11 -1
13 -1 -1
15 -1 16
12 -1 -1

Create a line chart and then select the Y axis and set the Y scale minimum to 0.

Select one of the marker lines (say Buy column values) and then use Format, Data Series, Pattern option and set Line = None and Marker Style to + and set the colour of the market that you want. Do the same for the other 'sell' marker series except selecting '-' as the marker pattern.