Hi guys,
I want to create rules/filters for charts/pivot charts with an excel sheet. The table is built to be populated with information from a user form but at the starting point it is blank, no information.
I cannot developed pivot charts and filters needed while the table is empty? Is there a way to do this? See below pivot chart based on beds.
Also when the charts are developed I need them to update automatically after each new entry. Each entry is completed using a user form.
I hope this makes sense. Please help if you can, thank you so much.
I want to create rules/filters for charts/pivot charts with an excel sheet. The table is built to be populated with information from a user form but at the starting point it is blank, no information.
I cannot developed pivot charts and filters needed while the table is empty? Is there a way to do this? See below pivot chart based on beds.
Also when the charts are developed I need them to update automatically after each new entry. Each entry is completed using a user form.
I hope this makes sense. Please help if you can, thank you so much.