Chart

[justine]

I have a chart set up with 6 dept's with hours worked for each month. I want to show a total at the bottom of the chart for each dept. w/out the totals showing up on the actual grid part of the chart. Can I do this?

Thx

[Mark W.]

See the Excel Help topic for "Display or hide a data table in a chart".

[justine]

I think I asked it wrong. I have the data tables on the chart. The month totals are what I want to show on the chart, but under the data table I would like an extra row that totals each column and I don't want this part on the actual chart. Can I do this?

[Mark W.]

Oh. Have you considered using the Camera toolbar button to create a "picture" of the worksheet cells containing your departmental totals and then placing it beneath the Plot area of your chart?

[Calicat]

Is this true for all types of graphs? I have a pie chart, and this oprion does not appear to be available?

[Mark W.]

Originally Posted by Calicat

Is this true for all types of graphs? I have a pie chart, and this oprion does not appear to be available?

What doesn't appear to be available?

[Calicat]

If I manually click on a chart, select chart options, there is no tab for data tables. I wanted to record a macro to see some code for adding a dat table to a chart.

I tried with a pie chart, and an XY scatter.

I am looking at a VBA way to add a data table to a chart, which summarizes some basic data. The chart is NOT embedded in a worksheet, and cannot be, as the data ranges are variable each time the macro is run.

So far, I tried:

With cht
.hasdatatable = true


and

Activechart.datatable = true

and I got errors for each type of syntax.

[Jon Peltier]

Ah, data tables. I don't use data tables. They are inflexible in what they allow you to present in them, and in how they allow you to format them. And they take up valuable chart real estate.

If I need a table to accompany the chart, I create the table in a spare worksheet, linked to the data in other sheets, and I embed the chart in the worksheet adjacent to the table. I can format it however I want, I can include any data I want, whether or not it appears on the chart. I can even include annotations to the table.

I usually don't bother, but you can even format the sheet around the table and chart so it looks like the two form a single unified entity

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

[Mark W.]

Calicat, see my 2nd recommendation above.

[Calicat]

Jon - I was hoping to avoid this, and add a simple table to my chart, as the macro is all set.

I will have to add to the macro to now embed it in a new worksheet? I actually used most of your code from the other day to create my graph!!

Mark - I will also look at this option.