Hi,
I'm charting a Pivot table and have multiple labels in my horizontal x-axis. From the Pivot table, first column is a label and the second column is a date, and then it's the data for those two. When I chart this and add the data labels to the chart, it is showing the date the long way, vertical 90 degrees, so it fits, but the label is showing horizontally, so it doesn't fit and overlaps each other. Now I would like to remove the date from the chart, as I only need the label in the chart, but need the date in the pivot table, but when I click off multi-level labels it keeps the date and removes the labels. How can I keep the label and remove the date, or how can I make the label vertical 90 degrees?