Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Chart data labels only displaying every other line in Excel 2007?
I'm working on a report, and when I use the chart to display the data graphically, the labels for each piece of data is only showing every other one. Example: Data1, <blank> Data3, <blank>, etc.
How can I get these to all display? I've already tried adjusting the font, making it extremely small, and it still gives the same result.
Thanks all.
1 Answer
- ?Lv 51 decade agoFavorite Answer
Click on the chart to select it, then go to Layout / Axes / (whichever axis you want) / More Primary Axis Options
If Vertical, change the 'Major unit' to 'Fixed' and specify the number.
If Horizontal, under 'Interval Between Labels', change from 'Automatic' to 'Specify Interval Unit' and specify the number.
Not sure if this will solve your problem, but I was able to manipulate both axes labels by doing this.