Re attach Charts to their Table

Hi Barry,

Sounds good. As Jerrold seems so confident, I'll try making another template, to check again, that my observation was as I said it was and if that don't work I'll have to find another way to store it.

Being curious, if all the formulea and other parts of the project are saved why would saving an empty table linked to a chart make any difference ?

Also, You would think that high-lighting the chart and calling up the inspector, you would be able to re-install the lost chart data bits, would you not ?

Thanks for time and interest. I'll try all suggestions anyway.

Hi Jerrold,

I have replied to your post twice but they are not showing on the Forum. Don't know why.

Ah! that one showed up.

The gist of previous reply was. Being new to Numbers I cannot swear absolutly, I did nothing else so will try again.

I think It's easier to try the same again first. If it don't work then, then I will have to find another way to store for re-use. I have a number of far more complex table/chart configurations that I want to transfer from Excel to Apple so if Numbers can't handle them then I will have to try another Spread Sheet. Unfortunately, I think Excel is going to take a lot of beating but must give it a chance. It's been suggested elswhere on this forum in so many words, that Numbers is not realy intended to be a grown up spreadsheet. That was in responce to a search for a way to get a system 'time stamp' that did not update every time the table refreshed. Pitty.

Thanks for your time and the interest.

Hi Jerrold, Hi Barry,

I have just tried twice more to save the working Table, with all it's entries in place, as a Template and same results.

There is one thing I felt was a strange to have to do: The chart on sheet 2 (the main one to be read) seemed not to want to update when the table was altered. It seemed to have something to do with being a separate sheet so I copied the the charts as a group to the first sheet, reduced it quite small and hid it behind the Table so that the table could fill the page. This works fine in the original and 'SaveAs' copies.

Could this be what is confusing things ?

Will investigate.

Jerrold, Barry,

Above was the problem. I change several things on an original copy any one or combination of could have been the solution.

It seems that there is a possibility if more than one chart references a table it may have trouble saving as a template and detach both.

Another observation might be that because the second chart was a copy of another Grouped set it could not handle a second grouped situation.

Or it was the Grouping itself.

All should be used carefuly and tried first.

Hi Jerrold,

in this case they were, in ignorance on my part however. The problem with doing it that way is getting the overlays accurately aligned, with such a small scale, having all on the same sheet. What I did was a close overlay on the same sheet, 'Grouped' them, moved them to another sheet, 'UnGrouped' and individually expanded and adjusted each for best position and alignment. That seems to work ok. As I mensioned above there may be a problem with 'Grouping' if saved as a Template. It's something I still need to prove or eliminate. It would help if the arrow keys could be used to manipulate the stretch handles like the move function.

Another thought is; If I can choose a larger sheet for construction and change sheet size when finished ?

Thanks again for your help.

Jerrold,

I have just constructed a quick & simple Table with a chart on a second sheet and saved it as a Template. I then recalled it and it seemes ok. Have I not understood something ?

A problem I do have Know is a load of useless templates I can't get rid of. lol. anyone know where they are stored ?

Hi Jerry,

Sure, not having intimate know-how of Numbers software, it is all a matter of cause and effect at a very personnel level. If I had access to the written software it is still unlikely that I would find the whys. Like most people I speek from my own experiences. I don't think I have solved anything. If there's a bug it remains a bug. we can only avoid doing things we know may be a problem.

Since I removed the Chart copy however, I cannot do anything wrong with it. I have even removed all the entered data in the in the table and made a template and it still works when I use a copy. Everything points to that being the problem. But, it doesn't mean there are no other reasons for such failures.

The =Right(now(),5) formula produces the desired time format and acts like a normal 24hr clock. Entering 09:45 is accepted by Numbers as an entered time but are not treated the same.

I was only passing on a fact I had run across, while scratching for ways of doing things.

My question would be "what is the difference between the them if both are in time format"?

Thanks for the tip on removing Templates, I didn"t know where they were stored, I actually found it in an answer from questions already asked. Thanks anyway.

I am using 'Snow Leopard'. I didn't update because of all the bad write-ups I read about losing the use of third party softwares, even Apple stuff. Just didn't want the hassle. The search did not find the actual file name but I don't want to go down that road at the moment.

I've not really used these forums in the past and still finding my way around. My thoughts are, for example, How do knowledgable people, like yourself, find time to stay on the site and answer my foolish questions ?

Jerry, just out of interest, I have just found another Q&A about lost charts which "KEONEG" (think that's how it is spelled) answered.

See 4th question down in the "More like this" panel.