//excel chart as object to excel chart .

Hi . I have an excel chartobject. When i double click i can edit the chart
and the datasheet also appears where i can enter the data in that small
window.
1.) How can i convert it back to the Excel Chart. ?
2.) How do i change the source data ?
3.) How can i add / delete the Legends ?

AND, how do you assign a datasheet to the excel chart ?
rgds
Sanjay Kapoor

Hi,

Sounds more like a MSGraph object than an excel chart.

I don't think there is an automatic way to do this.
You would need to copy the data from the data sheet and paste into excel.
Then create an excel chart on that data.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sansk_23" wrote in message
...
Hi . I have an excel chartobject. When i double click i can edit the chart
and the datasheet also appears where i can enter the data in that small
window.
1.) How can i convert it back to the Excel Chart. ?
2.) How do i change the source data ?
3.) How can i add / delete the Legends ?

AND, how do you assign a datasheet to the excel chart ?
rgds
Sanjay Kapoor