Category: GRAPHS AND CHARTS

Display data from the Grand Total column of a Pivot Table on a Stacked Pivot Chart

{ 31 Comments }

Assume a simple Sales dataset from which a Pivot Table has been created.  The Pivot Table has been sliced by two columns of the dataset.  To represent data graphically, a Stacked Pivot Chart has been created from this Pivot Table and the chart is placed on a separate worksheet (of the same workbook).  The Stacked […]

Read More →

Show Slicer selection on a Graph

{ 7 Comments }

Assume a simple Sales dataset from which a Pivot Table has been created.  The Pivot Table has been sliced by two columns of the dataset.  To represent data pictorially, a Pivot Chart has been created from this Pivot Table and the chart is placed on a separate worksheet (of the same workbook).  Now let’s say, a […]

Read More →

Applying conditional formatting to column charts

{ 8 Comments }

Line of Business (LoB) wise CAGR (%) is shown in range A3:B8.  A benchmark growth rate is shown in cell B11.  The task to show a column chart of the data presented in range A3:B8.  LoB’s with a CAGR (%) greater than the benchmark rate should appear in Green colour and those with a CAGR (%) […]

Read More →

Create charts on different sheets by clicking a button

{ 6 Comments }

Assume a five column database with the first column containing codes, second one containing a separator, third one containing some alpha values, fourth one is a combination of the first three columns and the last column has response times. One may want to create as many charts as there are codes in column A.  The charts […]

Read More →

Updating charts for columns added to source data in Excel 2003

{ 0 Comments }

Having created a graph from a certain source data, if columns get added later to the source, they do not automatically append to the graph.  While this is easy enough to accomplish in Excel 2007 and higher versions, doing the same in Excel 2003 is a different procedure altogether.  Instructions are very clearly mentioned in […]

Read More →