Excel Dashboard

**finlain** · 08-06-2009, 02:15 PM

Hi
I found a fabulous Excel Dashboard that I am trying to recreate for web analytics. I have the majority of the formula's figured out but there is one area to the right that has a very small chart and it uses error bars. I have tried to recreate and when I do the chart area behind the physical chart is too big. Have you ever seen anything in relation to doing this. I do not have 2007 only 2003.
This is what I am trying to replicate.
http://blog.immeria.net/2008/08/even...oards-fun.html

Been a while Andy, glad you are stil at it!

Elaine

**Andy Pope** · 08-07-2009, 05:40 AM

can you post your workbook as it's not clear what your problem is.

I assume the chart to the right you refer to is the line with shaded area.
Not sure how error bars fit in to the problem.

**finlain** · 08-26-2009, 11:36 AM

Hi Andy
This is what I had so far.

Thanks
Elaine
PS just trying to display a legible chart on the right in that very small space like the example that I sent to you in my previous post.

**Andy Pope** · 08-26-2009, 12:00 PM

You just need to make a very small chart.

I have included as chart that is a line with 2 extra series as area, which provides the shading.

**finlain** · 08-26-2009, 12:18 PM

Thanks Andy! Apparently there maybe more features in Excel 2007 as the first example I posted looked "much cleaner". I appreciate your help, as always

Elaine