chart and data

[Pennny]

Trying to get 4 dining rooms with 4 tables set up to work in a pie chart

I need a function that can move a client from 1 dining room to another and to a different seat.Can some one help with this pleaseÉ
Also I have managed to get 1 pie chart working I saved in 4 different work books (clearly not thinking). Can some tell me how to get all of my pie chart into my master spread sheet as when i move it using the paste with function the pie chart and the spread sheet are no longer working together.

This is the 3rd time I have tried to post this and it has not gone if this is not clear I am willing to send an attachment of what I am trying to do
Thanks Penny

 

[Pennny]

I want to clarify what I am looking for help with, I have a spreadsheet of clients with food restriction that sit in 6 separate dining rooms that holds 6 tables, each having a designated seat. The seating plan and room is constantly changing for these clients. I am trying to set up a easier method of moving these clients from table to table, seat to seat room to room. I have constructed a pie chart for 1 table in 1 dining room with 6 seats.
I am looking for help on a function that would simplefy the move rather than using the copy and paste function. The other problems is I have tried to copy and paste, duplicate my pie chart to use for other rooms, seatings and tables, however it will not reflect the new data, another words it doesn't work. Could someone help with info on how to get it working?
Once again thanks for your time
Pennny

 

[thisoldman]

You have 216 seats. With six seats per table, you require 36 charts.

Here's how I would organize the data, before creating the first chart.

[TABLE="class: grid, width: 194"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Diet[/TD]
[TD]Table[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Joanne[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Madeleine[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Nicola[/TD]
[TD]B[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Victor[/TD]
[TD]B[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Sebastian[/TD]
[TD]B[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Claire[/TD]
[TD]B[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Kevin[/TD]
[TD]B[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Stewart[/TD]
[TD]B[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Elizabeth[/TD]
[TD]B[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]

The table extends downward.

The table number, increments after every sixth row.

Using the first six rows of data, cells A2:C7, create the first chart for Table 1 and get the formatting correct. Copy that chart and paste it to its final position.

Paste a second copy of the chart next to the original chart. Select that second copy and bring up the right-click menu. Choose "Select Data..."

At the top of the dialog box that pops up, is a cell selection box labeled "Chart data range:". With the contents of the selection box highlighted, you can replace that original range by selecting cells A8:C13.

If the formatting is different from the original chart in the copied chart (the data labels insist on getting lost for me), copy the original chart again. Next select the copied chart. Then go to the ribbon, in the Home tab, select the little downward pointing triangle directly below the Paste Clipboard. Choose "Paste Special...". Select "Formats" and click "OK". This should correct the formatting. You can now move the chart to its final position.

Then repeat the process until done. As long as the only changes are made in columns A and B, the chart will update with those changes. Changing cells in column C may cause you trouble.

If you would like to play around with my test spreadsheet, I posted it at Dropbox - diet_pies.xlsx

 

[Pennny]

Wow!!! I will play around with this on the weekend; if this works, the hours you have just saved me ......I have no words, thank you doesn't seem adequate, but sincerely thank you!! I will get back to you next week and let you know if this works.

 

[thisoldman]

I'm happy to have helped.

Thank you for writing "Wow!!!". That made me smile for quite a while.