When I make a bar graph of the attached data from a pivot table, the year does not plot on the x-axis, only the month. How do I get both to plot? I copied and pasted the pivot table so it may look a little strange.
When I make a bar graph of the attached data from a pivot table, the year does not plot on the x-axis, only the month. How do I get both to plot? I copied and pasted the pivot table so it may look a little strange.
Use a 2 series chart and use the year as a legend entry.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks