Chart type

[lezawang]

Hi
I have excel sheet which has a chart. I want to know what type of char is that. It could be smooth line or scattered line or wave, or anything really. How can I know what type of the chart is used? Thanks

 

[Smitty]

If you click on the chart, you can go to Chart Tools > Design > Change Chart Type, and the dialog will show you the current chart type. If you want exact specifications about the chart returned, you'd need to use VBA. You can see Excel MVP Jon Peltier's site for that: www.peltiertech.com. He's pretty much the smartest chart guy on the planet.