This document gives idea about how to design a interactive data analysis method (for beginners). Now a days customer need is increased and they want to change data according to our there needs. Every organization concentrating on WHAT IF ANALYSIS, by using a simple components we can allow higher level data interaction. Looks simple but way of representation makes difference
To make user to change the data we are using ” INPUT TEXT component”…!!!!
The designed model looks like this..
Take a Stacked column chart as shown in figure… Here i have used 12 “Input text component….! ” Link to cell and data insertion little bit tricky
Initially choose Input text component and Make the fallowing settings
But to make formula to use unchecked the Treat all input as text check box.
After placing all the components in a proper manner.. what all data you are going to change in a dashboard will reflect in a chart automatically as well as in blue coloured Total Display !!
By using formula we can make dashboard according to our need
Any changes suggestions always welcome,File attached for further understanding..