View original (French)

[Excel] Set text on the X-axis (chart)

Solved
gouzatrash Posted messages 30 Status Membre -  
 tibo -
Hello,

I'm working on a chart where the x-axis values are not numeric but text. However, when I plot the chart, there are numeric values on the x-axis while I want text instead.

Thank you in advance.

EXCEL 2007
Configuration: Windows XP / Firefox 3.6.13

2 réponses

Réponse 1 / 2
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
Have you chosen a "line" or "curve" type chart? And not a scatter plot?
42
gouzatrash Posted messages 30 Status Membre
 
I hadn't done it, now it works thanks!
0
agouti52
 
I had the same problem, thanks for the tip, tontong. The only downside is that in my application, connecting the dots between the different abscissas (even in the same columns) doesn't really make sense. But oh well, we'll make do ;)
0
Ilapasditbonjour Posted messages 1 Status Membre
 
Indeed, the type of chart is very important in this situation. And if you still want a chart without connected points, just click on all the points of the chart, go to the “Format” tab, select the “Outline” option, and click on “No outline” and the line connecting the points will disappear :)
0
tibo > Ilapasditbonjour Posted messages 1 Status Membre
 
I have been struggling for 2 hours to create a scatter plot with text on the x-axis, without finding any solutions. Your solution works perfectly and is very simple, thank you!!
0