Excel - line chart wanted

  Graham. 15:40 11 May 10
Locked

I have an Excel chart showing daily dates from March to May in Column A and a number between 1 and 100 in column B. All I need is a simple line chart showing the number against the date (roughly, of course) just to show trends.

I can't make any sense of Help, it seems to be for a different version to my 2007.

  Fermat's Theorem 15:58 11 May 10

It really is easy. Just highlight columns A and B, then choose the Insert Tab, select Line and you've got it!

Hope this helps :-)

  onthelimit 16:01 11 May 10
  Graham. 16:04 11 May 10

Been doing that. I downloaded the data from an external source, I think I need to change the format of Col B, it's coming up as % and the chart is just a right angle.

  VoG II 16:31 11 May 10

It sounds like you have text instead of numbers in column B.

Try selecting the column B data, on the Data tab click Text to Columns then click Finish.

  Graham. 16:46 11 May 10

Tried that, still getting % on the vertical axis, chart is a right angle.

  VoG II 16:51 11 May 10

In a spare cell, what does

=ISNUMBER(B2)

return. If it returns false then you have text, not numbers.

  Graham. 17:03 11 May 10

Back in 5 mins

  Graham. 17:26 11 May 10

It says TRUE.

  Graham. 17:29 11 May 10

There's only data in rows 1 - 69, is the chart trying to include rows 70 + infinity?

I know this should be simple, I could do it in '97.

  VoG II 17:30 11 May 10

Right click the Y-axis, select Format Axis and check that the scaling is sensible and that the number format is sensible.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac