LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Source Data in Chart Karen Charts and Charting in Excel 3 August 15th 08 09:30 PM
Change source data of a pivot chart MRIreland Charts and Charting in Excel 1 July 23rd 08 03:15 PM
Edit Chart to Change Source Data wamiller36 Charts and Charting in Excel 2 July 2nd 08 07:17 AM
Using a named range as a data source for a chart MichaelR Charts and Charting in Excel 4 June 16th 08 04:15 AM
Change source data in a pivot chart johnb Charts and Charting in Excel 4 September 12th 07 04:40 PM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"