CODEWITHSUNDEEP
excel
Ralf
Ralf

Reputation: 1108

Simple Excel Chart

I have this table in Excel:

Excel table

and I want to have a line chart with x: CalendarWeek, y: PriceAvg. So I select A1:B5, click on Insert->2-D Line and get this "chart":

chart

What is going on here?

Upvotes: 0

Views: 44

Answers (1)

Dominique
Dominique

Reputation: 17493

What you need, is the "X Y (scatter)", instead of 2-D line.

enter image description here

Upvotes: 1

Related Questions