Forum Discussion

spoony's avatar
spoony
Icon for Helper I rankHelper I
9 years ago

Slicer for chart legend

I have a table with 4 columns: Month, input, output, combined. Month is the x axis on the bar chart showing months/year data and the other columns are whole numbers data. Instead of plotting 3 charts,...
Need Help
  • spoony's avatar
    spoony
    Icon for Helper I rankHelper I
    9 years ago
    It seems this is not possible to do from the other posts. So next best thing is hierachy drill down. How would i create psuedo hierachy from my table between the columns?
    • tjd's avatar
      tjd
      Icon for Impactful Individual rankImpactful Individual
      9 years ago

      My suggestion would be to use a clustered column chart with the following setup:

      1. Shared Axis (3 items which become the "drilldown":
        1. Input
        2. Output
        3. Combined
      2. Column Series: Month
      3. Column Values: whatever common measure is that you've got monthly data on - sales, revenue, etc.