Apply formatting to individual charts

The example below is of a Business Scenario chart which uses a calculated member for the Actual member.

The mapping for the calculated member, my actual below is defined as follows on the XLCubedBusinessRules sheet:

The formatting can be specified on the XLCubedFormats sheet at the chart level. The Item Name can be set on the chart. Open the Dynamic Chart Properties window, change the Chart name on the General Options tab, and choose OK.

You can now specify which formatting to apply at the chart level in the XLCubedFormats sheet.

For the chart that you have called right_chart you can apply a different format to that which you have called left_chart as seen below.