I have a request to create a chart in the same format as an existing Excel spreadsheet. I have attached a sample application illustrating the required result. The request includes the chart containing vertical total columns (A-Total, B-Total, C-Total). Of course the actual chart is much more complicated than in the attached application.
I have achieved the desired result using a mapping table (Region_Table) and changing the charts presentation to horizontal.
Is there a way to change the column header height, when the presentation is horizontal, without changing the height of all detail cells?
Also, when the chart is exported or sent to Excel, it returns to the vertical presentation. Is there a way to get it into Excel, so that the user can manipulate the cells, in its horizontal presentation?
