I'd like to be able to to adjust bar widths on an open-high-low-close stock chart (AKA: candle chart). This is possible to do on a column chart, but I'm not able to find a way of doing it on this particular chart.
To bring this chart up, first paste the following example data into your spreadsheet and select all of it:
111.20 111.74 109.09 109.21
113.92 114.27 111.56 111.70
114.28 114.45 112.98 113.89
113.62 115.13 113.59 115.06
114.73 114.84 113.20 113.64
114.49 115.14 114.42 114.93
113.95 114.94 113.37 114.62
113.97 114.21 113.22 113.66
115.08 115.13 114.24 114.73
Then:
insert -> other charts -> all charts -> stock chart -> select second one from the left.
it should read "open-high-low-close" when you hover over it's icon.
What I'd like to do is make the bars 50% wider or so. If it is not possible to do it with standard excel commands, is there a way to program this with basic?
Thank you.
Bookmarks