If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Time Sensitive - Stacked Cluster Columns
I currently have a bar graph with "cluster columns" and would like to
breakdown my data further to create what I would consider "stacked cluster columns". Example: Let's say I own a Petshop and I would like to chart a 12 month trend of the quantity and breeds of certain pets I had in stock. I can easily show the quantity by a column graph which indicates the category of "dogs" with a blue bar and "cats" with a red bar placed side by side. I would like to modify this graph to a stacked graph adding the specific breeds within the "dogs" and "cats" categories. Is this possible in Excel? |
#2
|
|||
|
|||
Time Sensitive - Stacked Cluster Columns
Hi,
See Jon Peltier's page of links for more information on cluster & stacked column charts. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy tlarson475 wrote: I currently have a bar graph with "cluster columns" and would like to breakdown my data further to create what I would consider "stacked cluster columns". Example: Let's say I own a Petshop and I would like to chart a 12 month trend of the quantity and breeds of certain pets I had in stock. I can easily show the quantity by a column graph which indicates the category of "dogs" with a blue bar and "cats" with a red bar placed side by side. I would like to modify this graph to a stacked graph adding the specific breeds within the "dogs" and "cats" categories. Is this possible in Excel? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
merging columns - one date, one time | batfish | Worksheet Functions | 2 | October 28th, 2005 04:02 AM |
time sheet to calculate 2 different columns | John Sullivan | Worksheet Functions | 1 | October 21st, 2005 06:48 AM |
How to make a stacked bar chart using time? | Jon Peltier | Charts and Charting | 0 | February 3rd, 2005 05:56 AM |
Outlook 2003 Terminal Server Time Zone issue | Robert Strom | Calendar | 2 | May 26th, 2004 10:50 PM |
Clustered and stacked columns at the same time | Patrick | Charts and Charting | 4 | November 19th, 2003 05:36 PM |