change chart source from range to raw data

[daithimcc]

(Excel v X for Mac)
I'm writing a simple vba program for creating various charts. I woul
like to be able to delete the data used (and keep the charts). Is i
possible to do this in vba? I know how to do it manually; clicking on
chart series, then the formula bar and pressing f9. (The problem ma
not be worth solving, as I suppose the raw data has to be stored b
Excel in the workbook anyway, so this may not save any/much space)
Anyway I would be grateful if anyone could let me know how this can b
done. Thanks
Davi

 

[Debra Dalgleish]

Jon Peltier has instructions for a few methods of delinking chart data,
including the one you described. I assume they'll work on a Mac:


http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/DelinkChartData.html

 

[daithimcc]

Thank you Debra. That did it perfectly (and very simply!