Good afternoon, Team,
I would like to have 8 different charts for 8 different regions in one page without interacting each other.
At the moment, I cannot do that and I had to create 8 different sheets for the information required (just by not choosing not syncing option)
Is there any way I can create 8 regions occupancy in one sheet.
Date and Service can sync, but I do not want my charts to sync with Region.
Please see attached for reference:
Thank you
Hi Aye,
You can set the visual level filter on each chart to a specific region, then you don't need the Region Slicer at all.
That said, I suggest you don't use a stacked area chart for this type of data. The regions should not be on the horizontal axis with the lines/areas connecting one region to another. The regions are distinct from one another, whereas the line connecting them implies they are related. A typical use for line/area charts is to show trends in continuous data collected at equal intervals. For example, data over time, with time/dates on the horizontal axis.
I suggest you put the dates in the horizontal axis.
Mynda
Hi Mynda,
Thank you so much for answering more than I requested.
It is so relevant and I now updated to time and dates on the horizontal axis.
It is reading very well now.
Regards,
Aye
