Excel - line chart wanted

  Graham. 15:40 11 May 2010

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 2010

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 2010
  Graham. 16:04 11 May 2010

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 2010

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 2010

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

  VoG II 16:51 11 May 2010

In a spare cell, what does


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

  Graham. 17:03 11 May 2010

Back in 5 mins

  Graham. 17:26 11 May 2010

It says TRUE.

  Graham. 17:29 11 May 2010

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 2010

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.

Elsewhere on IDG sites

Huawei MateBook X Pro review

8 digital brands that designed custom typefaces to save millions

How to speed up a slow Mac

Comment résoudre des problèmes d’impressions ?