OaklandJim
Well-known Member
- Joined
- Nov 29, 2018
- Messages
- 855
- Office Version
- 365
- Platform
- Windows
The client does live auctions. She wants to have a data entry area where data is entered real time for events as pledges are received. (I think that a dedicated data worksheet is indicated.)
She wants a dynamic figure -- I am using clustered bar chart -- that updates as pledges are added to the data so the audience can see the action. The objective is to show the figure to the audience in real-time as the pledges are made. There will be an assistant who enters the data.
Any suggestions about how to display a dynamic Excel figure real time? Ideally the Excel "container" (menu at the top and stuff at the bottom of the Excel Window) is not shown/visible to viewers. I hope for something that looks like a powerpoint slide.
Presenting it is my biggest challenge I think. "Separating" data entry and figure shown is another challenge. The best I could think of is to set up a mini lan between two laptops and then use a separate figure workbook that has links to the data input workbook.
She wants a dynamic figure -- I am using clustered bar chart -- that updates as pledges are added to the data so the audience can see the action. The objective is to show the figure to the audience in real-time as the pledges are made. There will be an assistant who enters the data.
Any suggestions about how to display a dynamic Excel figure real time? Ideally the Excel "container" (menu at the top and stuff at the bottom of the Excel Window) is not shown/visible to viewers. I hope for something that looks like a powerpoint slide.
Presenting it is my biggest challenge I think. "Separating" data entry and figure shown is another challenge. The best I could think of is to set up a mini lan between two laptops and then use a separate figure workbook that has links to the data input workbook.