Chart question

ATAHER

New Member
Joined
May 9, 2010
Messages
20
Hi to all , My question is regarding charting When i try to chart the stock pricies i can not figure out the curve because the different between each reading is very small example :9/4/2014 25.019/3/2014 24.369/2/2014 24.489/1/2014 24.888/31/2014 25.148/28/2014 25.31 So the curve can not show me the clear "Zigzag" i mean ther is no charp corner movements , it is look like straight line .is there any way that enble me to make above stock reading clear in curve and waht is the best chart type to use Best Regards & Thanks in advance .
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Just make sure that the scale of the y axis is suitable. You can change the lower and upper bounds by right clicking it and choosing Format Axis.
 

ATAHER

New Member
Joined
May 9, 2010
Messages
20
Sorry, I cant do it .Would you explain it in more details .Thank alot
 

Watch MrExcel Video

Forum statistics

Threads
1,122,604
Messages
5,597,128
Members
414,126
Latest member
jellevansoelen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top