--- Forwarded Message ---

Hi,

Thanks for highlighting the problem. I rarely used Trixcel
myself though I modified the original program to remove some bugs and
translated it into English (somewhat). But I think I understand your
problem. Whenever Trixcel draws the chart, it creates a hidden
worksheet, and its name has the format of "Triangle<no.>Data" where
<no.> is the chart sequence, e.g., 0, 1, 2, and so on. It is in this
hidden worksheet that your input chart data is converted into chart
coordinates and stored so that it is actually the chart coordinates
that is plotted and not exactly what you entered. The chart appears
to plot your entered data exactly because it has the labels 10, 20,
30, and on, but actually the chart coordinates is the one that is
used.

Consequently, when you copy and paste a source chart,
intending the new chart for fresh data plotting, the target chart
unfortunately still maintains the old links to the same hidden
worksheet as the the source chart. So any changes to the first data
set affects the second chart as well because they all belong to the
same hidden worksheet. To overcome this problem, you have a fair bit
of work to do:

1) From the main menu, choose Format|Sheet|Unhide. From the list,
choose the worksheet with the name "Triangle<no.>Data".

2) Create exact copies of the worksheet "Triangle<no.>Data" based on
the number of charts you have minus one. So if you have 3 charts,
then create 2 copies of the worksheet "Triangle<no.>Data", and give
them a sequential numbering, e.g., if the original worksheet
is "Triangle0Data", then the next two copies should have names
like "Triangle1Data" and "Triangle2Data". To create copies of the
worksheet, ensure the "Triangle<no.>Data" worksheet is current (i.e.,
you are currently viewing it and the worksheet tab with the
name "Triangle<no.>Data" at the bottom of your screen is
highlighted). Then choose from the main menu: Edit|Move or Copy
Sheet. In the dialog box,
click the option "Create a copy", and click OK. Modify the names of
the worksheet copies to the format as given previously.

3) For each chart, click on any point. You will see the function in
the function window. Modify the link from the original
worksheet "Triangle<no.>Data" to the newly copied
worksheet "Triangle<no.+1>Data".

4) Now go to the worksheet "Triangle<no.+1>Data" and modify the old
links from cell B26 onwards to the where the new chart is located.
For example, if the copied Chart2 is in Sheet2, then modify the
links "Sheet1" to "Sheet2" because that is where the copied chart is.
Instead of individual modifications you can make sweeping changes in
a go by choosing the Edit|Replace option from the main menu to find
every occurance "Sheet1" and change it to "Sheet2".

I hope this helps.

--- Original Message ---

At 09:13 PM 21-03-02, you wrote:

Chris...
I recently informed you of downloading your Ternary diagram software
for Excel. I have a problem which I'm hoping you might be able to
assist with.

I am attempting to produce a number of Ternary diagrams from one
spreadsheet. However, after producing one diagram and going on to
produce the second, the data plot of the first is changed to mirror
that of the second. Obviously this isn't what I want! The charts I am
producing are looking fanatastic, but I'm only able to temporarily
produce one at a time - no use at all for paper writing!

I've tried a number of approaches, but all either do not work or
would be too time consuming for their realistic application...what do
you suggest?