Excel - Axis data points

%3CLINGO-SUB%20id%3D%22lingo-sub-882282%22%20slang%3D%22en-US%22%3EExcel%20-%20Axis%20data%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-882282%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20problems%20with%20the%20x-axis%20data%20points%20and%20filtering%20them.%20It's%20Excel%202013%2C%20column%20chart.%3C%2FP%3E%3CP%3EFor%20the%20x-axis%20I%20have%20%22%3DRecruitment!%24D%2413%3A%24Q%2413%22.%20This%20are%2014%20data%20points.%20after%20I%20marked%20this%20section%2C%20Excel%20shows%20me%2037%20other%20(empty)%20data%20points%20(see%20picture).%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20rid%20of%20the%2037%20useless%20datapoints%3F%3C%2FP%3E%3CP%3EThe%20column%20chart%20itself%20only%20shows%20my%2014%20data%20points%2C%20but%20if%20I%20want%20to%20filter%20some%20points%2C%20I%20have%20to%20un-click%20the%2037%20as%20well%20as%20they%20are%20appearing%20in%20my%20chart%20out%20of%20the%20sudden.%20What%20kind%20of%20bug%20is%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134111i1BDD60250013058D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Bild1.png%22%20title%3D%22Bild1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-882282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have problems with the x-axis data points and filtering them. It's Excel 2013, column chart.

For the x-axis I have "=Recruitment!$D$13:$Q$13". This are 14 data points. after I marked this section, Excel shows me 37 other (empty) data points (see picture).

How can I get rid of the 37 useless datapoints?

The column chart itself only shows my 14 data points, but if I want to filter some points, I have to un-click the 37 as well as they are appearing in my chart out of the sudden. What kind of bug is it?

 

Bild1.png

0 Replies