Forum Discussion
horizontal axis labels at top and bottom
Thanks for the reply!
I'm hitting a snag:
The third line of your response says "Select any series, then click Edit under Legend Entries (Series)."
I have done that and I'm looking at the Select Data Source pop-up, and the Chart Data Range is empty, with a message saying 'the data range is too complex to be displayed'. I swear this is just a very simple line graph.
I've tried continuing by selecting the first thing under Legend Entries and copying and adding and pasting, but then when it comes to the point where I open the Horizontal (Category) Axis Labels, there's nothing there to copy.
Please advise.
Thanks!
breepa It doesn't matter that the Chart Data Range box is empty.
You should still be able to edit the Series values.
If the Axis label range is empty, you can skip the step to copy it.
- Okay, I think I have everything correct and the labels are in place but now I have an additional data line that is out of sync with the one I copied, and the labels on the top aren't aligned with the ones at the bottom. They're in the correct order, but the bottom set is wider than the top set.
Any thoughts?Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.