Forum Discussion
Create a graph with dates on one axis and text on the other
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 name...
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.
HansVogelaar
I could not attach a file, but this the table
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!
Here are some alternatives.