HIDDEN CHART SOURCE DATA - KING OF EXCEL

Sunday, January 19, 2020

HIDDEN CHART SOURCE DATA

HIDDEN CHART SOURCE DATA

When building reports or dashboards in Excel, you may choose to hide the actual source data from view. However, in some cases this will cause the actual chart itself to disappear as well.
In this tip, I’ll show you how to adjust your chart settings to persist even when underlying source data is hidden.

COMMON USE CASES:

  • Designing reports with the source data and visuals on the same tab
  • Preventing users from accessing or modifying a chart’s raw source data
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

Popular Posts