Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stacked Columns (two separate companies, 3 time periods)
I am trying to build a stacked column chart representing income, expense, and
profit for two separate companies, x & y, during three time periods (1996-1998, 1998-2001, 2001-2005) If successful, the chart will have two columns in each of the time periods. I have been able to create the two columns in three time periods, but Excel will not let me enter or change data for company x in all three time periods or enter/change with both companies in a single time period? Thanks in advance for any advice on this problem. -- al |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stacked Columns (two separate companies, 3 time periods)
Hi,
have a look here for details on how to create a clustered stacked chart http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "al" wrote in message ... I am trying to build a stacked column chart representing income, expense, and profit for two separate companies, x & y, during three time periods (1996-1998, 1998-2001, 2001-2005) If successful, the chart will have two columns in each of the time periods. I have been able to create the two columns in three time periods, but Excel will not let me enter or change data for company x in all three time periods or enter/change with both companies in a single time period? Thanks in advance for any advice on this problem. -- al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating return for multiple separate time periods | Excel Worksheet Functions | |||
How do I join a date and time that are in separate columns? | Excel Discussion (Misc queries) | |||
Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
Merging separate date and time columns into one | Excel Discussion (Misc queries) | |||
Time Sensitive - Stacked Cluster Columns | Charts and Charting in Excel |