Microsoft Office 365 - Excel
Design custom dashboards with data from Excel Online Spreadsheets.
Numerics lets you easily display custom data from your Excel Online Spreadsheets.
Once you’ve chosen the type of widget you want to add to your dashboard for Excel Online Spreadsheets, you will first need to connect your account. The account connecting process is standard for Excel Online Spreadsheets, you can see more info about connecting an account here. Once the account is added / chosen, the Spreadsheets and Worksheets accessible by the account get populated automatically. Please choose the appropriate spreadsheet and worksheet that you would like to bring in numbers from. Sometimes, if you’ve added an account earlier, the spreadsheets & worksheets might require to be refreshed to fetch any new sheets that might have been added since.
Next is the Spreadsheet Data Range. The data range is different for each widget depending on its type and has to be defined as the Numerics Widget Data Specification. Below, each of the types of widgets are listed along with examples of data ranges that are compatible with the Numerics Widget Data Specification.
Excel Online Spreadsheets Custom Count
For the range, specify a 1 column by 2 row range. The first row cell must contain a number value and is displayed as the main number tally. The second row cell is displayed as a postfix (units) for the main number displayed and can be any value including date or text. Providing a single row cell value will display the number without any postfix.
Excel Online Spreadsheets Custom Label
For the range, specify a 1 column by 2 row range. The first row cell must contain a text value and is displayed as the main text label. The second row will be displayed as a postfix (units) below the custom text label and can be any value including date or text. Providing a single row cell value will display the custom text label without any postfix.
Excel Online Spreadsheets Custom Count and Change
For the range, specify a 1 column by 3 row range. The first row and the second row cells must contain number values. The first cell value is displayed as the main number tally. Below this, the widget will automatically calculate and display the percentage difference from the values of the two cells. The value of the third row cell is displayed as a postfix (units) for the number tally and can be any value including date or text. The first and second row cell values are required, the third row cell displayed is optional.
Excel Online Spreadsheets Custom Line Graph
For the range, specify a 2 column by ‘n’ rows range (Max 31). The first column must contain number values that are used as y-axis values to plot your custom line graph. The first value from the second column forms the postfix or units for all the values presented on the line graph and can be any value including date or text. The first column values are required, the second column is optional.
Excel Online Spreadsheets Custom Named Line Graph
For the range, specify a 3 column x ‘n’ rows range (Max 31). The values of the first column will form the names of the items plotted on the x-axis. The second column must contain number values that are used as y-axis values against each item of the x-axis to plot your custom line graph. The first value from the third column forms the postfix or units for all the values presented on the line graph and can be any value including date or text. The first and second column values are required, the third column is optional.
Excel Online Spreadsheets Custom Pie Chart
For the range, specify a 2 column by ‘n’ rows range. The first column must have the names for which the values are provided and can be any format including text, while the second column must have number values that are used to form the slices of the pie. The pie chart automatically calculates the percentage value of each part of the pie, takes the top 5 values to draw 5 slices of the pie. If there are more than 5 values the remaining values are added up to create the 6th slice named ‘Other’.
Excel Online Spreadsheets Custom Toplist Funnel Chart
For the range, specify a 2 column by ‘n’ rows range. The first column must have the names for which the values are provided and can be any format including text, while the second column must have number values that are used to form the funnel chart. Additionally, the first row of both the columns must have the heading titles for the two sides of the top list. The Top List Funnel chart will automatically sort and pick up the top 5 items from your custom data and draw a funnel chart.
Excel Online Spreadsheets Gauge
For the range, specify a 4 column by 1 row range. The first column cell must contain a numeric value that will be displayed as the minimum value on the gauge visualization. The second column cell must have the current value followed by the maximum value in third column cell. The fourth column will be displayed as a postfix (units) below the gauge and can be any value including date or text.
Excel Online Spreadsheets Timer
For the range, specify a 1 column by 2 row range. The first row cell must contain a start date and time value that is used to calculate and display a timer with the time passed since or remaining for the event. The second row will be displayed as the event name below the timer and can be any value including text or number.
Excel Online Spreadsheets Custom Hour Density Chart
The widget displays a 24 hour clock starting at 00 and broken into 24 equal slices, with each slice of the pie representing an hour. Hours with the highest values are the brightest, while hours with lower values are incrementally more transparent and closer to the background color of the widget. For the range, specify a 2 column by ‘n’ rows range (max 24). The first column must list the 24 hours of the day and must be a number value between 0 and 24, while the second column must have number values that indicate the value of each hour.
Excel Online Spreadsheets Custom Day Density Chart
The widget displays the calendar days of the month, with each block representing a day. Days with the highest values are the brightest, while days with lower values are incrementally more transparent and closer to the background color of the widget. For the range, specify a 2 column by ‘n’ rows range. The first column must list the days of a single month, and must be in date format. The second column must have corresponding number values that indicate the value of each day.