Charting on two axis with colums and lines

PIJim

Board Regular
Joined
Jul 29, 2005
Messages
143
I have a pivot table that includes the following information.

Machine Type (9 different types -need to show one at a time)
Month (need to show all months with data)
Criteria 1 Target (data) -each data is an average of a large data set
Criteria 1 Actual (data)
Criteria 2 Target (data)
Criteria 2 Actual (data)
Criteria 3 Target (data)
Criteria 3 Actual (data)

I would like to show the criteria target data with columns and the actual with lines.
Criteria 1 (target and actual) on primary axis
Criteria 2 & 3 (target and actual) on secondary axis.

I achieved this but when I refresh my pivot table, I lose my formatting. I also lose the format when I select a different machine type.

I am trying to report on the performance of production lines (individually) based on 3 sets of criteria which all have defined targets. the primary axis ranges between 80% and 100%. The secondary axis ranges between 1.5% and 25%.

Any help with this one would be greatly appreciated!!!
Thanks, Jim
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

PIJim

Board Regular
Joined
Jul 29, 2005
Messages
143
Is my description of my problem unclear or is this too difficult?

Thanks,
Jim
 

Forum statistics

Threads
1,136,709
Messages
5,677,324
Members
419,688
Latest member
sarahmichelle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top