HOW DO I CREATE A STOCK CHART IN EXCEL?

Guest · Oct 18, 2004

DATA IS READY IN MY WORKSHEET:A FOR NAME, B FOR HIGH, C FOR LOW, D FOR CLOSE.
I CHOOSE THE STOCK CHART.
THEN I PUT THE APPROPRIATE NUMBERS IN THE "VALUES:" BOX.

WHEN I PRESS "NEXT", HELP SAYS THAT I HAVE TO ARRANGE DATA!

CAN YOU PLEASE HELP ME?

Tushar Mehta · Oct 18, 2004

Probably, but could you please stop shouting?

Check http://office.microsoft.com/en-us/assistance/HA011179421033.aspx

Another, and possibly more common, data set would have dates in col. A.

In the 2nd step of the chart wizard, ensure you select the 'Series in
columns' option.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

HOW DO I CREATE A STOCK CHART IN EXCEL?

Guest

Tushar Mehta