Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
Bubble - skipping data | Charts and Charting in Excel | |||
Comparing two different sets of data with common element | Excel Worksheet Functions | |||
insert vertical grid line that is linkedto a certain data element | Charts and Charting in Excel | |||
Prevent equation from skipping data when referencing import data? | Excel Discussion (Misc queries) |