how do you create a calculated field in a chart?

J

john.kaye

I have a datasource where the data is stored as a factor of 60000 times
the real units. To display this data in a pivotchart, I created a
calculated field which divided the source data by 60000. When I
display the data in a chart, I am struggling to do the same.

How can I produce the calculated field for the chart?
Or can I fiddle the y axis scale to display y/60000?
Or can I link the set of data in the pivot table to the chart.
Currently the chart uses the same SQL Query which the PivotTable
started with before the additional calculations.

Thank you in advance for your help.
Best Wishes, John.
 
J

JohnK

I have resolved this - the original code I started with did not bind
the chart directly to the pivot table. Once I did that, everything
fell into place.
Best Wishes, John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Scatter charts for name with two values 0
create chart with column axis 10
Read back the source data from chart 0
Labeling on independently stacked line chart 0
Visio 2010 - Deleted shape data fields not disappearing 1
Possible? Variable X and Y data sources and Auto Charting 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1

Top