Create a graph with dates on one axis and text on the other

%3CLINGO-SUB%20id%3D%22lingo-sub-3063592%22%20slang%3D%22en-US%22%3ECreate%20a%20graph%20with%20dates%20on%20one%20axis%20and%20text%20on%20the%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3063592%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20scattered%20graph%20in%20which%20dates%20are%20displayed%20in%20the%20X%20axis%20and%20a%20names%20are%20displayed%20on%20the%20Y%20axis.%20So%20that%20I%20can%20see%20when%20there%20is%20a%20bigger%20concentration%20of%20the%20names%20throughout%20the%20time.%20I%20think%20a%20scattered%20graph%20is%20the%20best.%3C%2FP%3E%3CP%3EI%20am%20using%20excel%20for%20MSO%20365%2032%20bit%20version%202102.%3C%2FP%3E%3CP%3EThese%20is%20the%20data%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDates%20for%20the%20x%20axis%3C%2FP%3E%3CP%3E2023-02-15%3C%2FP%3E%3CP%3E2023-05-03%3C%2FP%3E%3CP%3E2024-08-20%3C%2FP%3E%3CP%3E2024-08-30%3C%2FP%3E%3CP%3E2025-11-09%3C%2FP%3E%3CP%3E2025-12-15%3C%2FP%3E%3CP%3E2026-02-17%3C%2FP%3E%3CP%3E2026-03-20%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3EBrands%20for%20the%20y-axis%3C%2FDIV%3E%3CDIV%3ELAND-ROVER%3C%2FDIV%3E%3CDIV%3ESKODA%3C%2FDIV%3E%3CDIV%3EPEUGEOT%3C%2FDIV%3E%3CDIV%3EMERCEDEZ%3C%2FDIV%3E%3CDIV%3EBMW%3C%2FDIV%3E%3CDIV%3EKIA%3C%2FDIV%3E%3CDIV%3EMITSUBISHI%3C%2FDIV%3E%3CDIV%3EVW%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3063592%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

 

I would like to create a scattered graph in which dates are displayed in the X axis and a names are displayed on the Y axis. So that I can see when there is a bigger concentration of the names throughout the time. I think a scattered graph is the best.

I am using excel for MSO 365 32 bit version 2102.

These is the data:

 

Dates for the x axis

2023-02-15

2023-05-03

2024-08-20

2024-08-30

2025-11-09

2025-12-15

2026-02-17

2026-03-20

 

Brands for the y-axis
LAND-ROVER
SKODA
PEUGEOT
MERCEDEZ
BMW
KIA
MITSUBISHI
VW
 

Thanks!

3 Replies

@sandra92 

An XY Scatter chart must use numeric values for both the x-axis and the y-axis. It cannot use text values for either of the axes.

If you provide more detailed information, preferably also attaching a sample workbook, we might be able to come up with a suggestion.

@Hans Vogelaar 
I could not attach a file, but this the table

sandra92_0-1642430118127.png

sandra92_1-1642430264830.png

And I would like a plot in which it shows when is the brand last available.

But I guess it is not possible then, since I cannot use text values for an XY Scatter chart. Thank you in any case!

 

@sandra92 

Here are some alternatives.