Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How can I get the monthly columns (ie: July Actual & July Budget) in a
stacked chart to sit side by side with a space before the next month (August Actual & August Budget) and so on for each month. |
#2
![]() |
|||
|
|||
![]()
Do you want to unstack the chart to convert it to a clustered chart?
Chart menu Chart Type select a clustered column subtype that you like. Are you trying to cluster stacks of columns? Here are some links: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ WCH CHART PERSON wrote: How can I get the monthly columns (ie: July Actual & July Budget) in a stacked chart to sit side by side with a space before the next month (August Actual & August Budget) and so on for each month. |
#3
![]() |
|||
|
|||
![]()
Jon,
No, they want them stacked to show non-operating profit and then operating profit on top so you can add them both to get the total profit and then he wants to see the budget write beside for the month. The links you listed showed a double column stack by month which is what I was looking for. Thank you greatly! Lori - WCH Chart Person "Jon Peltier" wrote: Do you want to unstack the chart to convert it to a clustered chart? Chart menu Chart Type select a clustered column subtype that you like. Are you trying to cluster stacks of columns? Here are some links: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ WCH CHART PERSON wrote: How can I get the monthly columns (ie: July Actual & July Budget) in a stacked chart to sit side by side with a space before the next month (August Actual & August Budget) and so on for each month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel |