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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

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,141,068
Messages
5,704,093
Members
421,327
Latest member
Msh

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