Partager via

Excel Services: Charting and Visual Analysis

  • Article

I have been extremely busy lately and haven't been able to update this blog as much as I would like. However, I have been speaking with many of you frequently over the email. I'm glad I was able to help most of you out. Please keep the questions coming, I love hearing from customers.

Excel Services Charting vs Excel Charting: What's the Diff?

Excel Services Charting work very differently from Excel Charts. Excel Services Charts:

  • Load as PNGs (Pictures) rather than objects
  • Cannot be selected, moved, or created
  • Do not support pictures, or Objects on top of them
  • Do not support gradients
  • Most importantly, all 3D charts are down-converted to 2D charts

However, they do update based on the cell reference that was updated (via Parameters)

Example of a 3D to 2D chart conversion

 

What type of charts are Unsupported?

Surface Charts and Grouped Charts

Comments

  • Anonymous
    July 13, 2008
    PingBack from http://www.fuzzlinks.com/2008/07/13/sherman-on-excel-and-bi-technology-excel-services-charting-and-visual-analysis/

  • Anonymous
    August 19, 2008
    I am working on a project that requires pulling the data from a spreadsheet cell and inserting That data into a document that can summarize each spreadsheet's entry. The documents are procurement department Request for Quote spreadsheets that are emailed To potential suppliers, who then enter part number price information and return the speadsheets Back the procurement agent. If the Supplier is unable to provide a price quote, there is a cell Labeled Supplier Comments on the spreadsheet where the Supplier is to enter a reason for not being able to submit a price quote. For instance, 'Unable to machine forged titanium'. These price quote spreadsheets are saved to one networked folder. I need to be able to pull the data from each spreadsheet to a summarizing document. Is it possible to pull data from spreadsheets in a central location like this? I would really appreciate any insight or information referral you could give me. Thanks, Dan

  • Anonymous
    December 04, 2008
    Hi Dan, This is definitely possible. Please email me.