Skipping every other data element when charting
When I am charting it is skipping every other data element/row. So for
example if I have sally with 40% and then Joe with 70% and then Mary with 80% it only lists Sally and Mary on the chart but shows the bar for Joe, just doesn't list his name under the bar. Why is that? |
Skipping every other data element when charting
Hi,
Double click the category axis and on the scale tab make sure the setting of 'Number of Categories between tick mark labels' is 1. Cheers Andy flegendre wrote: When I am charting it is skipping every other data element/row. So for example if I have sally with 40% and then Joe with 70% and then Mary with 80% it only lists Sally and Mary on the chart but shows the bar for Joe, just doesn't list his name under the bar. Why is that? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com