change chart source from range to raw data
 

(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

--
Message posted from http://www.ExcelForum.com

change chart source from range to raw data
 

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/...ChartData.html

daithimcc wrote:
(Excel v X for Mac)
I'm writing a simple vba program for creating various charts. I would
like to be able to delete the data used (and keep the charts). Is it
possible to do this in vba? I know how to do it manually; clicking on a
chart series, then the formula bar and pressing f9. (The problem may
not be worth solving, as I suppose the raw data has to be stored by
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 be
done. Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

change chart source from range to raw data
 

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

--
Message posted from http://www.ExcelForum.com