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.
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.
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.
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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks