Charting Usage This Year vs Last Year
I have a chart that currently shows all of a customers orders. The x axis the the total number of orders per month and hte y are the month names. I create the data on the chart by pushing a button from my customers database record which goes to related records in orders, sorts by month, then uses the current data on the chart.
I'm wondering if it is possible to have the data broken down to current fiscal year and previous fiscal year. I would ideally like 2 lines on the graph showing each fiscal year instead of just one very long graph showing the years drawn out.