A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
So, do you mean you want to keep the seating plan in its original up/down orienation, and you just want to change the orientation of the 1100 seat numbers on the image?
If that is the case you have 2 options that I can think of ...
Find the original file, edit the file numbers there.
The other is to take a screen capture, flip the image, then zoom way the <expletive deleted> in and tediously insert new numbers over top of the old ones.
OK, looking at the image again there is one more option. Use the current image as a guide, then manually recreate the whole thing in Excel.
OK, I just figured it out. You can automate recreation of the diagram. There still is a lot of manual work to get the shape and color right, but generating the seat numbers right is a simple concatenate formula
granted, this block is not in the right space on the worksheet, you have to displace it right to allow for east block, but you get the general idea. All you have to do is adjust the locked $ row and column identifier for the first seat in each block, then copy and paste to fill the rest of the block.
I just used default highlight colors, you could select custom colors that are closer.
Adjust the row and column heights as needed
Here is a quick and dirty recreation of the West block:
https://1drv.ms/x/s!Am8lVyUzjKfpiRkjqFo7gylnrC96
- enter the required row and column labels
- paste the formula =CONCATENATE($A4,"-",B$3) in cell B4
- Now copy and paste left and down
- drop out or delete unneeded "seats"
- add color to taste
- add wheel chair graphics (you can merge cells to do that.
- repeat with the other sections.