How are charts linked to their source data?

Have a program that creates charts based on a single
worksheet of
data.  However, there are other worksheets included but
which are not
referenced for any charts.  These serve merely as historical
data for
each month.  Tried to be economical and create only the
worksheets
necessary, i.e. a master table, and historical data for each
month, as
necessary

The problem is that, as a new month is added, the charts no
longer
point to the first/master worksheet.  Instead, charts
reference the
new month's worksheet.

If there is no way to "lock" the charts to a
specific sheet, might
need to create all 12 months's worksheets, and just hide the
future
months?

bc


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---

On Sep 24, 12:20 am, bc <clark.b...comcast.net> wrote:
> The problem is that, as a new month is added, the
charts no longer
> point to the first/master worksheet.  Instead, charts
reference the
> new month's worksheet.

Hi,

Extracted charts reference a data worksheet using an index.
The index
relates to the order that the sheets were created in.

If your template looks like this.

    0 Master
    1 Chart (pointing to 0)

Then you should be able to use it to create a workbook like
this:

    0 Master
    1 Jan
    2 Feb
    3 Etc
    4 Chart (pointing to 0)

But not like this:

    0 Jan
    1 Feb
    2 Etc
    3 Master
    4 Chart (pointing to 0)

The chartex tool will be extended to allow modification of
the links
within the extracted chart file but that is still a couple
of months
off.

John.
--




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---