Format Data Table

[Guest]

I am using Excell 2003.
I have a bar chart that indicates; the number of prod A, prod B, prod C and
the Total # of products, by month; April Ex: A=100, B= 200, C=50 and total
= 350. My chart has a data table listed below the chart.

My boss wants me to eliminate the "total" column from my graph but keep it
in the data table. Is there a way to do this?

I can eliminate the "total" column from the graph, but that also takes it
out of the data table. Does anyone know how to keep it in the table but not
in the graph itself? I would appreciate any help you can give me.

thank you - aurora

 

[Guest]

You won't be able to achieve this in the charting data table. However, you
can create a custom data table via worksheet cells and Excel's camera tool
and incorporate that table into your chart. These links provide further
explanation:

http://j-walk.com/ss/excel/odd/odd04.htm

http://www.processtrends.com/pg_charts_camera_tool.htm

 

[Guest]

Thank you so much. I really appreciate your help. I never even heard of a
"camera" in Excell, and this did exactally what I wanted and it was so easy.
Again, I can not thank you enough.

Aurora

 

[Guest]

I realize this is a month old, but I have another solution to your problem
that, in my case, is much easier to accomplish. Build your graph with all
the data including the total and show your data table. Once your graph is
complete, click on the "total" portion of the bar graph(selecting only the
total columns), choose "Format Data Series", change the area to NONE and the
border to NONE. Click OK. The total portion of the bar is now gone, and your
data table is still in tact. You may have to change your scale to better fit
your new graphed data. Caution: Once you select None for both border and
area and click OK, you will not be able to bring that part of the graph back.