Hi All, hoping/guessing I have an easy one here. I have a basic line chart with a trend line (started as a scatter however I believe the Scatter chart uses intervals on the X axis?) showing the number of terminations on a monthly basis, for the last five years. To avoid showing 60+ categories on the X axis, I would at least like the years to show if possible.
I tried to get creative by adding a column showing the year, however the chart still showed the data 60+ times, such as 2010 appeared 12 times.
Is there a way to create this chart so the years show (once) between 2010 - 2015, underneath the data for all months?
Thanks for any suggestions.
Sheryl
Bookmarks