Forum Discussion

sandra92's avatar
sandra92
Copper Contributor
Jan 17, 2022

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...
Charting
excel
office 365
HansVogelaar's avatar
HansVogelaar
MVP
Jan 17, 2022

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.

  • sandra92's avatar
    sandra92
    Copper Contributor
    Jan 17, 2022

    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!

     

Resources