Charting table detail and sum

I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)

Any help would be most appreciated,
Thanks

Sorry, "subtotals" are not directly supported in charts. But I'm not sure if you would really get the desired effect with a subtotal in charts. Since the individual employee groups share the same Y-axis as the total number of employees, you would most likely get many small bars and one long bar showing the total number of employees.
One alternative way is to add a second chart which just shows the total number of employees.

-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...

Charting table detail and sum

I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)

Any help would be most appreciated,
Thanks

Sorry, "subtotals" are not directly supported in charts. But I'm not sure if you would really get the desired effect with a subtotal in charts. Since the individual employee groups share the same Y-axis as the total number of employees, you would most likely get many small bars and one long bar showing the total number of employees.
One alternative way is to add a second chart which just shows the total number of employees.

-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...

Chart Question

I have numbers along the side of my chart in MB's.
The numbers a large so i want to format the number with ","
ie
I currently have 200000. I want to see 200,000 along the side fo the chart.
along the y axis.
ThanksIn the format button on the x or y axis tab, enter #,00.
Hope this helps
"Fab" wrote:
> I have numbers along the side of my chart in MB's.
> The numbers a large so i want to format the number with ","
> ie
> I currently have 200000. I want to see 200,000 along the side fo the chart.
> along the y axis.
> Thanks
>
>|||Sure did! Thanks!!
Fab.
"Ramani" <Ramani@.discussions.microsoft.com> wrote in message
news:270AC95B-08CE-45DF-B7B2-471CAA4620D1@.microsoft.com...
> In the format button on the x or y axis tab, enter #,00.
> Hope this helps
> "Fab" wrote:
>> I have numbers along the side of my chart in MB's.
>> The numbers a large so i want to format the number with ","
>> ie
>> I currently have 200000. I want to see 200,000 along the side fo the
>> chart.
>> along the y axis.
>> Thanks
>>
>>|||What format button?
--
Thanks,
CGW
"Ramani" wrote:
> In the format button on the x or y axis tab, enter #,00.
> Hope this helps
> "Fab" wrote:
> > I have numbers along the side of my chart in MB's.
> >
> > The numbers a large so i want to format the number with ","
> >
> > ie
> >
> > I currently have 200000. I want to see 200,000 along the side fo the chart.
> > along the y axis.
> >
> > Thanks
> >
> >
> >
> >

Chart Category Labels

How would I angle my category labels along the x axis of a Stacked Column
Chart. I can set the colors and and styles, but how do I go about making the
label or text sit at a 45 degree angle instead of vertical? Is there an
expression to place on the label property for the categories?This is currently not supported. It is under consideration for inclusion in
a future release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clint Jennings" <ClintJennings@.discussions.microsoft.com> wrote in message
news:613CADD4-2F13-469B-A1BA-EE25A02EAB1F@.microsoft.com...
> How would I angle my category labels along the x axis of a Stacked Column
> Chart. I can set the colors and and styles, but how do I go about making
the
> label or text sit at a 45 degree angle instead of vertical? Is there an
> expression to place on the label property for the categories?
>|||Thanks Robert.:)
"Robert Bruckner [MSFT]" wrote:
> This is currently not supported. It is under consideration for inclusion in
> a future release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Clint Jennings" <ClintJennings@.discussions.microsoft.com> wrote in message
> news:613CADD4-2F13-469B-A1BA-EE25A02EAB1F@.microsoft.com...
> > How would I angle my category labels along the x axis of a Stacked Column
> > Chart. I can set the colors and and styles, but how do I go about making
> the
> > label or text sit at a 45 degree angle instead of vertical? Is there an
> > expression to place on the label property for the categories?
> >
>
>