| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Dashboard - How was this done ?
http://www.ozgrid.com/charts/dashboa...orts-color.htm
Before I give-up and shell out the bucks for this utility, can any experts take a guess as to HOW exactly these mini-charts are being done in Excel with VBA ? The options I've come up with so far: - Charts within Forms - embedded shape objects - ActiveX component The author goes on to mention some Camera tool or something here ? http://www.exceluser.com/catalog/ab/landbook1.htm Also, what about these little guys ? http://www.ozgrid.com/charts/micro-charts.htm Are they "live" charts or just chart images I wonder ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Dashboard - How was this done ?
http://www.exceluser.com/catalog/landdash3.htm
says they are just small charts. Before I started spending money, I would take a look he John Peltier http://peltiertech.com/ and he Tushar Mehta http://www.tushar-mehta.com/excel/ See what you can do with charts. -- Regards, Tom Ogilvy "syswizard" wrote in message ups.com... http://www.ozgrid.com/charts/dashboa...orts-color.htm Before I give-up and shell out the bucks for this utility, can any experts take a guess as to HOW exactly these mini-charts are being done in Excel with VBA ? The options I've come up with so far: - Charts within Forms - embedded shape objects - ActiveX component The author goes on to mention some Camera tool or something here ? http://www.exceluser.com/catalog/ab/landbook1.htm Also, what about these little guys ? http://www.ozgrid.com/charts/micro-charts.htm Are they "live" charts or just chart images I wonder ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Dashboard - How was this done ?
On Feb 16, 10:37 pm, "Tom Ogilvy" wrote:
http://www.exceluser.com/catalog/landdash3.htm says they are just small charts. Before I started spending money, I would take a look he John Peltierhttp://peltiertech.com/ and he Tushar Mehtahttp://www.tushar-mehta.com/excel/ See what you can do with charts. -- Regards, Tom Ogilvy Wow, thanks for those outstanding links Tom....I'll be reviewing them tomorrow. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Dashboard - How was this done ?
As Tom points out, they are regular Excel charts. In some cases, the Camera
tool (built into Excel, though sometimes difficult to find) is used to put charts and tables into the desired arrangement for the report. The e-book goes into detail not only describing how to make the charts and use the camera tool, but also how to design a reporting system of workbooks that enables easy updating of the dashboard workbook at regular intervals (weekly or monthly) as the data in the linked sources changes. You can probably find more details about the dashboards on the ExcelUser.com site. The MicroCharts (BonaVista, www.bonavistasystems.com) and SparkMaker (Bissantz, www.bissantz.de) create live charts in Excel cells using specially designed fonts. OzGrid doesn't do you any favors by not prominently posting the web sites of the software creators, so you can learn more about their products. I've dabbled with these products, and while they seem promising, they are not sufficiently Excel-like to feel like a natural extension of Excel. The use of fonts is both clever and problematic, and their construction within .Net has led to problems with other VBA use, at least on my machine. Fernando Cinquegrani has very recently* shown how to use regular Excel charts, in conjunction with the Camera tool, to get very similar sparkline charts: http://www.prodomosua.eu/zips/sparklines.xls *one day before it appeared as a comment at the end of Edward Tufte's page describing sparklines: http://www.edwardtufte.com/bboard/q-...1OR&topic_id=1 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "syswizard" wrote in message ups.com... http://www.ozgrid.com/charts/dashboa...orts-color.htm Before I give-up and shell out the bucks for this utility, can any experts take a guess as to HOW exactly these mini-charts are being done in Excel with VBA ? The options I've come up with so far: - Charts within Forms - embedded shape objects - ActiveX component The author goes on to mention some Camera tool or something here ? http://www.exceluser.com/catalog/ab/landbook1.htm Also, what about these little guys ? http://www.ozgrid.com/charts/micro-charts.htm Are they "live" charts or just chart images I wonder ? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Dashboard - How was this done ?
On Feb 17, 10:09 am, "Jon Peltier"
wrote: As Tom points out, they are regular Excel charts. In some cases, the Camera tool (built into Excel, though sometimes difficult to find) is used to put charts and tables into the desired arrangement for the report. The e-book goes into detail not only describing how to make the charts and use the camera tool, but also how to design a reporting system of workbooks that enables easy updating of the dashboard workbook at regular intervals (weekly or monthly) as the data in the linked sources changes. You can probably find more details about the dashboards on the ExcelUser.com site. The MicroCharts (BonaVista,www.bonavistasystems.com) and SparkMaker (Bissantz,www.bissantz.de) create live charts in Excel cells using specially designed fonts. OzGrid doesn't do you any favors by not prominently posting the web sites of the software creators, so you can learn more about their products. I've dabbled with these products, and while they seem promising, they are not sufficiently Excel-like to feel like a natural extension of Excel. The use of fonts is both clever and problematic, and their construction within .Net has led to problems with other VBA use, at least on my machine. Fernando Cinquegrani has very recently* shown how to use regular Excel charts, in conjunction with the Camera tool, to get very similar sparkline charts: http://www.prodomosua.eu/zips/sparklines.xls *one day before it appeared as a comment at the end of Edward Tufte's page describing sparklines: http://www.edwardtufte.com/bboard/q-..._id=0001OR&top... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutionshttp://PeltierTech.com _______ "syswizard" wrote in message ups.com... http://www.ozgrid.com/charts/dashboa...orts-color.htm Before I give-up and shell out the bucks for this utility, can any experts take a guess as to HOW exactly these mini-charts are being done in Excel with VBA ? The options I've come up with so far: - Charts within Forms - embedded shape objects - ActiveX component The author goes on to mention some Camera tool or something here ? http://www.exceluser.com/catalog/ab/landbook1.htm Also, what about these little guys ? http://www.ozgrid.com/charts/micro-charts.htm Are they "live" charts or just chart images I wonder ?- Hide quoted text - - Show quoted text - Thanks much to Jon and Tom. Wow, this forum appears to be one of the best for Excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Dashboard | Excel Discussion (Misc queries) | |||
| Help in creating Excel Dashboard | Excel Discussion (Misc queries) | |||
| Dashboard for Excel | Excel Discussion (Misc queries) | |||
| Excel 2007 BI Dashboard | Excel Discussion (Misc queries) | |||
| dashboard I can use for Excel or PowerPoint | Charts and Charting in Excel | |||
Linear Mode
