Create Excel chart with specific data

[KhallP]

I created a chart in excel , the chart would be perfect, but the date values in the table are missing from the X axis, I don't know much about how to create charts just the basics, could you help me?

My Chart:

All Data:

 

[RoryA]

You've got non-date items ("Unknow") in there, which is why you haven't got a proper date axis. Where should they plot?

 

[KhallP]

You've got non-date items ("Unknow") in there, which is why you haven't got a proper date axis. Where should they plot?

hello friend, thanks for the answer, wouldn't it be possible to create a condition so that when the data were "Unknow" they wouldn't be inserted in the chart?

 

[RoryA]

Yes, you could add a new column that returns NA() if that date column doesn't have a date in it, or the date otherwise. Do the same for the data point. Then plot the two new columns, not the original ones.

 

[RoryA]

Please note:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Create Excel chart with specific data
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.