Bar Charts in Excel
I am creating basic bar charts in excel and only a few of my data labels on
the x axis are displaying. There is plenty of room between the tick marks, but it is just picking up some of the data from the worksheet. |
Bar Charts in Excel
Hi,
Assuming you chart is referencing all of the required data check the setting of the x axis scale 'Number of Categories between tick mark labels' is 1. Double click the x axis to bring up the format dialog. The setting is on the Scale tab. Cheers Andy Sam wrote: I am creating basic bar charts in excel and only a few of my data labels on the x axis are displaying. There is plenty of room between the tick marks, but it is just picking up some of the data from the worksheet. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 03:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com