Hello, I am trying to create the chart that compare Current year and Last Year Sale side by side.
I also attach the image below. The problem with the chart is that I tried to have the Order Date (Jan, Feb, Mar...) on the bottom
of the chart. If I move the Order date down the chart turn in to stacked bar chart.
Any suggestion?
4 respostas
Option - I
Swaping date fields
Option - II
Its a hack
Create a new sheet like this
Then create a dashboard and drag your First sheet as tiled and new sheet as floating.
Hide the header of year date field.
Adjust the alignment of both the charts, Hide the top headers.
Workbook (version 9.2) attached
Let me know If this help
Mahfooj
