You don't actually have to do a dual axis to get all your data into one chart, you just have to get you data set up correctly, and the pills arranged on the shelves correctly. Does the attached do what you want?
Book8.twbx.zip 16.5 KB
Hi Shawn, thanks a bunch for the reply! However, this is not exactly what I am looking for. I wanted to show it on dual axis because one of the metrics (bank balance in this case) would be on a much larger scale. With my sample data, it looks OK, but in my real data this presentation might turn out to be problematic. In addition, for dashboarding purposes, it might be best if I could fit all these into a smaller graph.
So do I actually need to reorganize my data to achieve this or is this still something achievable from the current organization of data?