Thank you - very clear indeed - but I am falling down earlier in the process . . .
I seem unable to create a proper new column chart in the first place: the object that Excel creates when I select Column for the Chart Type consists of narrow vertical lines which do not respond to changes in Overlap or Gap. The X-axis with dates is correctly presented, as are the numbers on the Y-axis.
Curiously, I copied a Column chart in the same Workbook, that I had created earlier and which correctly formatted and I can edit the Gaps etc, and when I paste it, it takes the odd "vertical lines" format and I can do nothing to change that - just as when I create a new Column chart.i
I have been exploring the options for a new chart and cannot find one whch gives me simple columns as per your example. I must be missing something but I can't see it !
|