4 Replies Latest reply on Jan 7, 2019 7:52 AM by Ghazi Muhamamd

    Need Help, creating side by side graphs of different dimensions (x-axis)

    Ghazi Muhamamd

      Basically got two different data source.

      My y-axis data is coming from one data source and the x-axis data is coming from the other data source.

      I want to create two different plots using the same the y-axis data ("Count of Business Activity").

      However for the the x-axis (WARDS) will be filtered by COUNT(CASE#).

       

      Summary:

      Plot 1 : Y-axis: (Count of Business Activity)

                  X-Axis : WARDS - Filtered by ( Top 5 COUNT(CASE#))

       

      Plot 2 : Y-axis: (Count of Business Activity)

                  X-Axis : WARDS - Filtered by ( Bottom 5 COUNT(CASE#))

      Graph = Plot 1 + Plot 2

       

      This easily accomplish on two separate worksheets (see worksheet 2 & 3). However I need this on the same worksheets.

      I'm open to any other graph options, as long it's some type of side by side graph comparison.