Hi
I am having an issue with a Waterfall chart, in that some of the columns do not start (or end) in line with the preceding / succeeding column. If I added a connector line to show where one column finished and the next started, the connector line wouldn't be horizontal (which I need it to be) but displayed at an angle. Interestingly, when I try to ensure that the subtotal column (i.e. invisible column underneath each visible column) is selected as the total (in the Format Data Point pane) I get 2 issues - firstly I can see that the visible columns are not positioned directly above the subtotal (i.e. invisible) columns. Some start are a little higher than where the subtotal column finishes, some start are a little lower than where the subtotal column finishes. Secondly - when I double click on a data point in the chart (to open the 'Format Data Point menu), the option to tick the 'set as total' box doesn't appear.
Any guidance on how to rectify would be massively appreciated!!
Thanks
WTS
Bookmarks