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 Excel CONVERT measurement list - Office Watch This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes. Multipliers Prefix these to some abbreviations to make other measurement units. For example 'k' for kilo plus 'g' for gram = 'kg' for kilogram. The more commonly used ones are in bold. Article posted: Sunday, 27 November 2011 there's more ... If you liked this article you'll LOVE our new ebooks. ORGANIZING OUTLOOK EMAIL - tame your Outlook 2010 Inbox 100+ pages of practical tips and help to streamline, automate and search your Inbox. More from Office Watch:

Learn Microsoft Excel Online - Excel Tips, Tricks, Charting Tutorials, Download Excel Templates, Excel Formulas and More... 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.

Tagxedo - Word Cloud with Styles 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:

SQL Query Statements Many useful Microsoft SQL Server query statements can be used when creating Microsoft Systems Management Server (SMS) 2003 reports, and they are briefly described in this section. To follow this discussion, you should have a basic level of SQL query statement knowledge and the ability to write queries such as the following: SELECT Name, Comment, CollectionID FROM v_Collection WHERE Name LIKE 'All Windows%' ORDER BY Name For information about how to write basic queries, see Query Fundamentals in the Microsoft SQL Server 2000 Books Online. Aggregate Functions Aggregate functions (such as SUM, AVG, COUNT, COUNT(*), MAX, and MIN) generate summary values in query result sets. Important Be aware that NULL values are not included in aggregate results. An example of using the COUNT(*) aggregate function is displayed in the following query (from the Count clients for each site SMS 2003 built-in report) and example result set. SELECT v_Site.SiteCode, v_Site.SiteName, v_Site.ReportingSiteCode, Inner Joins

BlueHarvest - Standards-based grading and two-way feedback organization 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

Online Charts Builder 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.

Cours Excel Contenu - Excel avancé Ce cours met l'accent sur l'utilisation du tableur EXCEL en tant qu'outil d'analyse et de simulation. Après une première partie destinée avant tout à familiariser les étudiants avec les outils d'édition avancées d'Excel (manipulations sur plusieurs feuilles, mise en forme et verrouillage des cellules, etc.), l'accent est mis, par la suite, sur les différentes manières de transcrire une réalité économique sous un tableur et la recherche des meilleures solutions afférentes (sous la forme d'une optimisation par exemple, ou encore sous la forme d'une simulation, etc.). La programmation VBA (macro-instructions) est un instrument indispensable dans ce cadre. L'étudiant doit déjà bien connaître les principes de base de l'utilisation d'un tableur (cellules, feuille de calcul, classeur, formules et fonctions simples, formattages et graphiques). Ce cours est principalement enseigné dans la filière Banque de la Faculté de Sciences Economiques. Ressources - Excel avancé

Related:  Softwares4barbesDataVisualisationData and visualizationRessources Excel