background preloader

Sparklines for Excel®

Sparklines for Excel®
Related:  ExcelPlug-ins

SparkLines Download source code - 4.41 KB Introduction Spark lines is this really cool way to visualize information. They are small high resolution line charts that show you where things are heading. Note that they don't show any detailed data, but only the general trend. Using the code An ASP.NET page (sparkline.aspx) is producing the binary output to generate the image. The table below shows the list of parameters that the image page (sparkline.aspx) can accept. Another ASP.NET page (SparklineTest.aspx) reads the SQL Server 2000 Northwind database and builds a dynamic table based on the data. Points of interest XY Chart Labeler A very commonly requested Excel feature is the ability to add labels to XY chart data points. The XY Chart Labeler adds this feature to Excel. The XY Chart Labeler provides the following options: Add XY Chart Labels - Adds labels to the points on your XY Chart data series based on any range of cells in the workbook. Even though this utility is called the XY Chart Labeler, it is capable of labeling any type of Excel chart series that will accept data labels. Download Getting Started If you need help getting started with the XY Chart Labeler, download this instructions document.

Pour commencer | MicroStrategy This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy for more information. Download MicroStrategy Analytics Desktop. Powerful analytics. Corporate email address:: Tell us more about yourself. Yes, I’d like to receive periodic messages from MicroStrategy. Analytics Pour commencer Pour commencer Choisissez comment commencer, avec 2 options simples. Discuter avec un spécialiste Il est plus facile de commencer lorsque vous pouvez parler dès à présent avec un spécialiste. Contactez-nous Téléchargez une version d’évaluation Téléchargez, installez et essayez une version complète de la plateforme Analytics avec toutes ses fonctionnalités pendant 30 jours et gratuitement. Télécharger la version d'essai Start experiencing our powerful software today. Leave your information below, and we’ll set you up with the trial that best matches your interests. Analytics Mobile Security SolutionsServices et SupportFormations Evénements Contact France|French

How to Make a Donut-Pie Combination Chart We’ve been dissing pie charts and donut charts quite a bit. So why then would we want a donut-pie combination chart? In Jorge Camoes’ How to create better pie charts, he showed a chart like this one. Jorge shows personal expenditure portions in the pie part of the chart. There was some discussion in the comments of my post regarding the construction of Jorge’s chart. Why are there so many series named “core” with the identical data? Below left is a donut chart created with this data. That left hand image looks like a dendrochronograph. Here’s how to make a similar chart with donut and pie series in the same chart. At first glance we seem to be stuck, but never fear, the chart doctor is here (the “voodoo” doctor, that is). Explode the pie. Now one-by-one move the wedges of the pie inwards (if you move the entire pie series en masse, the pie segments will remain stuck to the outer edge of the donuts). Using the pie-donut combo procedure described above, we can get by with a lot less data:

PowerPivot Microsoft PowerPivot pour Excel est un complément que vous pouvez utiliser pour effectuer des analyses de données puissantes dans Microsoft Excel 2010, en bénéficiant du décisionnel libre-service sur votre bureau. Dans cet article Présentation de PowerPivot pour Excel Utilisation de PowerPivot pour Excel pour donner du sens à vos données En utilisant PowerPivot pour Excel, vous pouvez transformer d’énormes quantités de données en informations significatives afin d’obtenir les réponses dont vous avez besoin en quelques secondes. Tirez profit d’outils et fonctionnalités Excel bien connues Traitez des quantités énormes de données en quelques secondes Chargez même les jeux de données les plus volumineux à partir de pratiquement toute source, y compris des bases de données, des flux de données, Reporting Services et des fichiers texte Utilisez les nouvelles fonctionnalités puissantes d’analyse, telles que les expressions DAX (Data Analysis Expressions) Découverte des fonctionnalités de PowerPivot

Atelier data visualisation une image vaut mieux qu'un long discours Atelier du 18 juin 2014 du Pôle Numérique de la CCI Bordeaux avec le témoignage de 10H11 : Atelier "Data visualisation une image vaut mieux qu'un long discours; Communiquez visuellement avec vos ... Atelier du 18 juin 2014 du Pôle Numérique de la CCI Bordeaux avec le témoignage de 10H11 : Atelier "Data visualisation une image vaut mieux qu'un long discours; Communiquez visuellement avec vos données". La visualisation de données ou data visualisation ce n'est pas un outil à la mode : c'est efficace ! Découvrez une nouvelle pratique de communication pour synthétiser et donner un impact visuel à vos données afin de mieux piloter votre activité ou interagir avec vos publics. Objectifs, méthodologie, outils et cas concrets.

Multi-level Pie Charts By: Jeff Clark Date: Thu, 27 Jul 2006 I promised a few months ago to describe something I call a Multi-level Pie Chart or Radial Treemap. I spent some time developing the idea as an alternative to the standard Treemap a few years ago before discovering that it had been done before. Despite the fact the idea has been around since 2000 it seems to be little known. I will illustrate the concept using survival data for the people on board the RMS Titanic which sank in 1912. We can use simple pie charts to show the proportion of people in the various passenger classes or the relative proportion of Males and Females. A Multi-level Pie Chart lets us see the proportion for second-order breakdowns. The idea can be extended to as many levels as desired. These images were created with an interactive tool that has a number of capabilities designed to alleviate this. Another useful capability is to have colour carry important information.

Exemple d'utilisation d'Excel Data Explorer Sign in Blog BI & EPM Blog en français traitant des sujets fonctionnels et techniques autour des solution BI & EPM Options Search Blogs Tags Archive Archives Vidéo: Un ETL dans Excel avec Data Explorer TechNet Blogs » Blog BI & EPM » Vidéo: Un ETL dans Excel avec Data Explorer Vidéo: Un ETL dans Excel avec Data Explorer Franck Mercier Franck Mercier Microsoft France 2,776 Points 3 2 1 Recent Achievements Blog Conversation Starter New Blog Commentator Blogger III View Profile 27 Feb 2013 9:08 AM Comments 0 Likes Data Explorer est un Add-In, pour Excel 2010 et 2013, permettant de récupérer des données provenant de plusieurs sources différentes et d’y apporter des modifications. Le lien ci-dessous vous présente Data Explorer en détail Mais j’ai souhaité faire une petite vidéo afin de présenter l’Add-in en action Bonne vidéo Data Explorer 0 Comments Comments

Banksy Art (FR) Eugene's Blog: How To...Draw a Polar Diagram in Excel I have added a new video to YouTube as part of my "How To..." series. This one is about drawing Polar Diagrams in Microsoft Excel. I teach about Polar Diagrams as part of the subject of Performance Measurement. They are really useful and easy to draw - they can graphically show gaps in performance without the detail of figures. It took me a few hours to create this video - I made so many mistakes that I had to re-record it several times.

Amazing Excel Add-ins XLTest Free Edition XLTest helps you to check the integrity of your spreadsheets far more quickly than with tedious cell-by-cell inspection. Its colour maps of the worksheets give you a visual overview that enables you to very quickly see inconsistencies. Its detailed listings are ideal for audit record purposes. To know more visit ASAP Utilities – The essential add-in for Excel users ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel. To know more visit Find Links Add-in To find the deleted Name Range and Ranges with “#Ref” error. and lots more useful stuff.To Know more Visit JMT Excel Utilities The add-in will help you in formatting, worksheet navigation, export picture as selection, etc.To know more Visit Excel Pivot Table Add-In My Menu ver 1.6 Amazing Excel Add-in This Add-in will help you in Name Manager Conditional Row Delete Add-In

Slavery Footprint - Made In A Free World Made in a Free World - A solution for business. Омогућава Преводилац Slavery Footprint Slavery exists... Deep within the supply chains of the products we love.Consider this... likely contains cotton that was picked by children in Uzbekistan who are forced to trade their school days for days in the fields. has Capacitors that are made with Coltan. 64% of Coltan reserves are located in Congo where child labourers are work from sunrise to sunset. there are estimated 200,000 child slaves working in Ivory Coast alone, harvesting 40% of the world's cocoa beans. Here's how it works The supply chain enslaves more people than atany other time in history. And they're working for you. No need to feel guilty... have the power to change this. voice matters Together, we'll work towards a world where everything you buy could have a new kind of "Made in..." tag. your slavery footprint by taking our survey. your results and encourage your friends to do the same. It all began with.. Justin Dillon The U.S.