need to change data table without changing chart

[LaNita]

I've created a chart and am displaying the data table. the data table show
display the total, but not in the chart which already pictures the total.
how do i do that?

 

[Tushar Mehta]

I've created a chart and am displaying the data table. the data table show
display the total, but not in the chart which already pictures the total.
how do i do that?

XL has limited capabilities when it comes to the data table. You may be
better off simulating the effect. See
Custom Chart Table
http://www.tushar-mehta.com/excel/newsgroups/data_table/index.htm

--
Regards,

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