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 →
{ 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 →
{ 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 →
{ 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 →
{ 0 Comments }
When creating a two y-axis chart (referred to as “Line-column” on 2 axis in Excel 2003), the usual way is to present column on primary vertical axis and line on secondary vertical axis. You may refer to my solution in this workbook.
Read More →
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 →
{ 2 Comments }
One may want to create interactive graphs by allowing users to select indicators and years to be plotted (via check boxes and scroll bars). I have presented three cases in this workbook.
Read More →
{ 0 Comments }
While it is easy enough to create a floating bar chart in Excel 2003 and prior versions, the problem is with data labels which do not appear at extreme ends for showing min and max values. You may refer to my solution in this workbook.
Read More →
Display data from the Grand Total column of a Pivot Table on a Stacked Pivot Chart
{ 31 Comments }