#DELTAGRAPH 7 TUTORIAL CODE#That said, 2007 is a disaster – why did MS change the graph object model without telling anyone? If you have code to manipulate graph objects, get ready for problems when you switch to 2007. So I would definitely characterize us as power users. I would say I have never met another Excel addin that does more than ours does. We even have a feature to automatically create a PowerPoint file using Excel graphs (creates slides and charts based on statitistical signficance). We might look at 1000 variables going back 9 months every 4 minutes. I own a small SW company that mines data from data historians using Excel. Maybe for this next iteration they will try to get power users involved in the business requirement solicitation and user testing. There is no chance Microsoft took this application into any investment bank because they would have screamed bloody murder. But don’t expect the guy who is trying to complete a merger valuation at 3:00 in the morning to relearn a program that he was an expert in. Wanna make Excel pretty for Grandma, fine – make it push button friendly and let her type in her contact list. Many traders, bankers, and analysts would literally throw the computer out the window if they had to deal with 2007 and after now working with it for over 6 months I can’t say that I would blame them. No one that I am aware of in the financial services industry has made the move to 2007 nor do they plan too because of what’s been done to Excel. On a related note, Microsoft must have only user tested 2007 with people who little to no knowledge of Excel. #DELTAGRAPH 7 TUTORIAL FULL#When there are individuals building full Sparklines functionality into Excel through open source and doing more for Excel charting then Microsoft did in all of Excel 2007, then we must do something.Īfter having read the Excel developers blog for the last year I understand why 2007 s**ks so bad, it seems they’re more interested in trying to get Excel to work on the web then actually making it better for the rest of us. I think we have a right to be angry and a duty to make our views known to Redmond. As someone who makes his living doing data analysis in financial services, Microsoft seriously handicapped my productivity when it redesigned the charting engine. If we could even kinda of go Wiki with it I think that would be even better. I can say that this is probably one of the things I worry least about in 2007, but I love your idea of putting together a longer version of the article detailing all of Excel 2007 Charts failings. I can understand both viewpoints as I spend my day in both 20 (as a business user not a developer). Some spacing around the margins of the charts may be altered, usually inconsequentially, but occasionally resulting in cropping of chart elements. The data is blurred, the markers may be increased in size, the fonts may be distorted. But I don’t think 2007 charts look any better than their 2003 counterparts. I do agree that creating and formatting charts in Excel 2003 is much easier. #DELTAGRAPH 7 TUTORIAL SERIES#Not only are the chart series in the 2007 chart blurry, the markers are larger than in the 2003 original, and the legend font has been somehow distorted. Why should my charts make me feel that I need new eyeglasses? This truncation is not an artifact of exporting the chart: it was present in the live chart as well.Īgain, the 2007 chart series are fuzzy. In addition, the right edge of the chart has been truncated. This 2007 chart has a fuzzy chart series. I’d rather have the series appear crisp, even if the lines are more jagged/ This is probably due to overaggressive antialiasing. The markers and lines of the 2007 chart series is fuzzy compared to the 2003 chart series. I looked at the charts side by side, and I still prefer the Excel 2003 rendering.Įach of the following pairs of charts shows the 2003 chart above the 2007 chart. Then I reopened the file in Excel 2007, and exported the same charts. I opened the file in Excel 2003 and exported a number of charts using my Enhanced Export Chart Procedure. I didn’t think I agreed with Jorge, but to be fair I singled out one of my files to take a closer look. Jorge admits that he doesn’t use Excel 2007 to actually draw his charts, but he reopens his file in Excel 2007 and uses the charts as they are rendered by the new graphics engine. In 14 Misconceptions About Charts and Graphs Jorge Camoes writes that he prefers the look of Excel 2007 charts to those in 2003.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |