Calculated Fields in Chart

**ruchi** · 03-13-2009, 01:12 PM

Hi All!

I have created a pivot table with two data fields and a calculated field. However, when I try to create a chart from that pivot table, somehow the calculated field does not shows up in chart. I am not sure what am i doing wrong. Till now, i have not tried writing a code, i was just trying to insert a chart so that i could create a combination chart.

Could somebody please help me!!

Please Login or Register  to view this content.

**Andy Pope** · 03-14-2009, 08:09 AM

Does the field display in the chart when done manually?

Can you post example workbook.

**ruchi** · 03-14-2009, 11:01 AM

No, the field does not get displayed even when i try to insert a chart manually.

Could you please help me?

**Andy Pope** · 03-14-2009, 11:09 AM

So if the field does not show up normally what makes up think a coded solution can make it appear?

I think you may need to create a normal chart based on the pivot table.
http://peltiertech.com/WordPress/reg...-pivot-tables/

**ruchi** · 03-14-2009, 01:53 PM

I know, that much i realized. That is why i did not take the trouble of coding it. I have already been through that article you have mentioned.
My question is why does this happen? Is it because I am trying to show percentage value with other two data fields which are not %. Though I am almost sure, that is not the reason because I tried to display only that data field in a chart, but still that value did not appear. I am not sure what to do next.

What do you think are the options that i have now to display it?

**ruchi** · 03-14-2009, 03:05 PM

I just recorded a macro and found this code, which plotted the chart atleast for one month!

But when i try to use the code to achieve for the entire pivot, it again does not plot the third data field! Plus it gives an error for the formatting part.. Please help..

Please Login or Register  to view this content.

**Andy Pope** · 03-15-2009, 07:36 AM

It could be that calculated fields are not included in the pivot chart.

It's impossible to tell whether you can create the chart any other way as we don't know what the source data layout looks like or the chart you are trying to create.

Can you post example workbook detailing what you are trying to do.