View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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