Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
EXCEL dashboards
How can I build dashboards in EXCEL myself ?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
EXCEL dashboards
See Charley's dashboards on http://exceluser.com.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "densmith99" wrote in message ... How can I build dashboards in EXCEL myself ? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
EXCEL dashboards
On Jun 3, 6:28*am, densmith99
wrote: How can I build dashboards in EXCEL myself ? Can you please give more information about what sort of things you want to show on a dashboard. I can give some info on a red, amber, green dashboard if that would be helpful. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
EXCEL dashboards
Artemis:
One I need to do at work is percent of a vendors stock on the shelf. So the vendor has 100 part numbers that I should be stocking. I would like a small chart or dashboard that goes red above 85% of parts on the shelf, amber between 84.9 and 80%, and yellow below 80%. I have multiple columns in a spreadsheet that have column names that are vendor numbers. Then the row contains the number of items stocked, as a percent. So the chart should read that cell, ane display a colored dashboard titled with th evendor number, and colored based on the value. In reality, I have many vendors so I want to make a big dashboard with all the vendors and quickly be able to see which are in the red or amber. Your help on this would be greatly appreciated. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
EXCEL dashboards
Use conditional formatting based on the percentage in the cell. Here's a
good place to start: http://contextures.com/xlCondFormat01.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tracy M." <Tracy wrote in message ... Artemis: One I need to do at work is percent of a vendors stock on the shelf. So the vendor has 100 part numbers that I should be stocking. I would like a small chart or dashboard that goes red above 85% of parts on the shelf, amber between 84.9 and 80%, and yellow below 80%. I have multiple columns in a spreadsheet that have column names that are vendor numbers. Then the row contains the number of items stocked, as a percent. So the chart should read that cell, ane display a colored dashboard titled with th evendor number, and colored based on the value. In reality, I have many vendors so I want to make a big dashboard with all the vendors and quickly be able to see which are in the red or amber. Your help on this would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
samples of sales dashboards in excel | Excel Discussion (Misc queries) | |||
Problems with Excel 2003 - Dashboards | Charts and Charting in Excel | |||
Problems with Excel - 2003.. Dashboards | Setting up and Configuration of Excel | |||
Problems with Excel 2003 - Dashboards | Excel Discussion (Misc queries) | |||
how to create dashboards using excel? | Charts and Charting in Excel |