View Single Post
 
Old 08-27-2017, 11:37 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Instead or 74 (3 times?) different charts, save data refreshing time into your Main table into additional column. And then design a report sheet(s), where you select (use Data Validation List) refreshing time, and according charts are displayed. Additionally you can design charts to compare with previous and/or next refreshing time.

The best design for this is to have a hidden sheet(s) where source data for charts is calculated accordingly refreshing time selected on report sheet.

When you want to have several report sheets, and you want to select refreshing time for every report separately, then you must calculate separate source table(s) for every report sheet.
Reply With Quote