Hi
I'm having some problem configuring a stacked column chart. The chart displays credit and debit for each of three offices - Cologne, London, Madrid for a three month period. I have attached the a screenshot of the chart as currently formatted.
- Cologne, London, Madrid and for the columns to be grouped by date i.e. offices for October, November and December.
My data is formatted as follows
Any help greatly appreciated
Regards
James O'Doherty
Solution Architect
WINSQL Ltd
Hi Georgi
Thank you for the reply. Is there any way to group the stacked bars by dates and to show each stack bar with the office name? I've attached a bar chart example to illustrate. I'd like to have London, Cologne, Madrid as Col #0, #1, #2 and Aug, Sep, Oct as Row #0, #1, #2 and the bar as stacked bar showing credit and debit as in your example.
James
here is the sample:
Hello James,
There are different approaches to solve this task. Please take a look on attached sample and one possible solution. If you have any questions, feel free to write me