Using the following data;
State | Amount 1 | Amount 2 | Percentage Amount 2 |
NSW | $500,000 | $89,000 | 17.80% |
VIC | $450,000 | $56,986 | 12.66% |
QLD | $350,000 | $36,589 | 10.45% |
Is it possible to chart a Clustered Column Chart that uses the variable "Percentage Amount 2" as the bars but the line should be the percentage of the total of Amount 2 divided by the total of Amount 1.
Example: Amount 2 [$182,575] / Amount 1 [$1,300,000] = 14.04%
The chart should like this;
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!