Chart Advisor

Chart Advisor : EasyCoded

Chart Advisor : EasyCoded — Thu, 25 Sep 2008 21:22:05 GMT

PingBack from http://www.easycoded.com/chart-advisor/

re: Chart Advisor

V. Garg — Fri, 26 Sep 2008 06:35:39 GMT

I tried installing it but it returns a useless error message:

"The installation of this package failed." with no indications as to how to correct this failure. Any help would be appreciated.

re: Chart Advisor

Nigel Thompson — Fri, 26 Sep 2008 10:04:00 GMT

Certainly will add more value to the casual users who I have seen spend an age trying to select then configure an appropriate chart. And by the way often fail!

My only request is an ability to define a preset chart style to meet our corporate guidelines on use of color etc.

Thanks

re: Chart Advisor

Matt — Fri, 26 Sep 2008 17:06:48 GMT

Just curious what the latest status was on adding in the functionality to create y-axis breaks for disparate data or the functionality to auto-place series labels?

Thanks,

Matt

re: Chart Advisor

Scott Ruble [MSFT] — Fri, 26 Sep 2008 19:55:58 GMT

V. Garg - at the top right of this page is an email link. If you can click that link and send me an email, I can correspond with you and try to trouble shoot your problem offline.

Nigel - thanks for the feedback.

Matt - this feature request is definitely on our radar but I can't comment on its potential availability at this time.

re: Chart Advisor

Sam — Sat, 27 Sep 2008 12:23:21 GMT

Can it advise that people should not use

a) Pie Charts

b) 3D Charts

c) Excessive Colors/Effects added in 2007 (at the cost of new chart types)

d) List things that have stopped working in Excel 2007 which were working fine in Excel 2003 - like inability to use F4 key to repeat format info....inability to double click on an axis to format...etc...etc..

Can it direct people to some good charting resources and articles like

Jon Peltier, Andy Pope, Perpetual Edge etc to learn charting and data vitualization....

re: Chart Advisor

atakee — Sun, 28 Sep 2008 11:09:35 GMT

hello! is there a version of the chart advisor for excel 2003 ?!?!

pls let me know: atakee@gmail.com

cheers

re: Chart Advisor

Scott Ruble [MSFT] — Tue, 30 Sep 2008 19:29:20 GMT

atakee - Sorry, there is not a version of chart advisor available for Excel 2003.

re: Chart Advisor

Al — Fri, 10 Oct 2008 08:49:07 GMT

Hello, please solve the following jaw-dropping problem in Excel 2007 first!

Here's my data:

a 66 97 147 133

b 274 167 150 79

c 8 32 46 45

d 33 57 41 29

e 41 20 4 16

f 4 3 22 5

g 4 12 12 5

Say, the data indicates trends of a, b, c, and so on.

Select the entire row a, draw a stacked line chart. Now from the chart, do a right click, select data, do the steps to add row g. What do you see? Total messed up values of g on the chart! Same thing continues as you keep adding more rows.

I'm using Excel 2007 with SP1.

re: Chart Advisor

Sean — Fri, 10 Oct 2008 12:37:33 GMT

Hi Al,

Can you be more descriptive of what you want to see? I have added the row for G and I see what I'd expect. Using a stacked line chart the points for G are stacked on A. So I see four points for A: 66, 97, 147, 133, and then I see the four points for G stacked upon them: 70 (66+4), 109 (97+12) and so on.

If this is what you wanted, but aren't seeing, then maybe you are adding each line incorrectly. In which case, try selecting the complete range and creating a stacked line chart. This will, by default, create 4 series of horizontal points A, B, C etc. Once you have done this, right click the chart and choose Select Data, and click on the Switch Row/Column button near the top of the Select Data Source dialogue box. This will then create the stacked chart with A as the lowest series and G as the highest. Being stacked, G will now represent the sum of all the values in each column.

If you are still having problems please explain in more detail what it is that you were expecting to see, and what it is that you are seeing.

Cheers,

Sean.

re: Chart Advisor

Al — Fri, 10 Oct 2008 20:25:25 GMT

Hi Sean,

Thanks much for your clear explanation!

Now I know it was *MY MISTAKE* (too bad I can't edit my previous comments anymore)! I was ignorant about the stacked line chart and was using it as a regular line chart for trending.

How to Create a Professional Chart using Excel 2007

Microsoft Excel — Thu, 26 Feb 2009 04:03:01 GMT

Today's author, Robin Wakefield, a Program Manager on the Excel team, discusses charts. As a new program