If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Is is me? Or is Excel 2007 Charting Lame?
Jon, You might want to check in with Steve R and Shyam on this. We can
all help each other here I am sure. See you in another NG. And maybe you might want to show up on our monthly conf. call. Next one is Feb 13 at 1 pm EST. Brian Reilly, MVP On Thu, 10 Jan 2008 15:32:09 -0500, "Jon Peltier" wrote: Good use of color is obviously key to good visualization, and Excel 2007 uses color way better than Excel 2003. You said I could "change the palette." Never mind that selecting colors is a skill I don't have: in 2003 I would have to, and in 2007 I don't -- so that's an improvement. You're correct. The themes are an improvement over the earlier palettes. So far I've found that the themes are harder to automate, but I may get better as I gain understanding of the underlying methodologies. Too bad the documentation is so vague. "Office-wide charts." You said in 3 words what took me 30. :-) Another big improvement. The lack of programmability of these objects in other applications makes this a big step backward. If you don't care about programmability, then it doesn't matter to you. I do care about programmability. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#12
|
|||
|
|||
Is is me? Or is Excel 2007 Charting Lame?
Brian -
We went through this shortly after Office 2007 went RTM. There are apparent properties and objects in the OM, and apparent help topics, but nothing actually gets executed in VBA. There seems to be a gap in the hierarchy, and the chart properties are the red-headed stepchildren in all of this. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Reilly, MVP" wrote in message ... Jon, You might want to check in with Steve R and Shyam on this. We can all help each other here I am sure. See you in another NG. And maybe you might want to show up on our monthly conf. call. Next one is Feb 13 at 1 pm EST. Brian Reilly, MVP On Thu, 10 Jan 2008 15:32:09 -0500, "Jon Peltier" wrote: Good use of color is obviously key to good visualization, and Excel 2007 uses color way better than Excel 2003. You said I could "change the palette." Never mind that selecting colors is a skill I don't have: in 2003 I would have to, and in 2007 I don't -- so that's an improvement. You're correct. The themes are an improvement over the earlier palettes. So far I've found that the themes are harder to automate, but I may get better as I gain understanding of the underlying methodologies. Too bad the documentation is so vague. "Office-wide charts." You said in 3 words what took me 30. :-) Another big improvement. The lack of programmability of these objects in other applications makes this a big step backward. If you don't care about programmability, then it doesn't matter to you. I do care about programmability. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#13
|
|||
|
|||
Is is me? Or is Excel 2007 Charting Lame?
One improvement that isn't eye candy:
The log scaling. (before you could only do base 10) Let me think of another one ... Thicker lines, well that is eye candy but it is nice On Jan 9, 4:49 pm, "Jon Peltier" wrote: Name one improvement that isn't eye candy. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "dparizo" wrote in message ... I'm guessing it's you. :-) I think charting in Excel 2007 is greatly improved. |
#14
|
|||
|
|||
Is is me? Or is Excel 2007 Charting Lame?
True, you can pick the base of the log, which to me doesn't seem to matter
much or make much sense, and you can pick the min and max, which do matter a great deal. I wish they allowed better control over tick spacing and labeling. Net result: a gain of at best 10% in log scale functionality. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Gklass" wrote in message ... One improvement that isn't eye candy: The log scaling. (before you could only do base 10) Let me think of another one ... Thicker lines, well that is eye candy but it is nice On Jan 9, 4:49 pm, "Jon Peltier" wrote: Name one improvement that isn't eye candy. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "dparizo" wrote in message ... I'm guessing it's you. :-) I think charting in Excel 2007 is greatly improved. |
|
Thread Tools | |
Display Modes | |
|
|