How to build a stacked column charts with secondary y axis and different scale

I want to plot a list of dates which have two attributes. The first attribute will have values that range from 200 to 400 (these bar charts will be on the top side of the axis with a scale of 20).

Additionally I want to plot the matching secondary attributes of each date. However these values range from .001 to .05. I want the bar charts for these to be downward-facing from the axis, scaled by .01 increments.

Any help would be greatly appreciated. Thanks

Hello,

you will need to make the numbers for the second data series negative (by multiplying with -1), then plot that calculated data on the secondary Y axis. Next, set the scale of the primary Y axis to a minimum of -100 and a maximum of 400 with major unit of 20. Set the scale of the secondary Y axis to minimum -0.05 and maximum 0.2 with a major unit of 0.01

Use different custom number formats for primary and secondary axis to suppress the numbers you don't want to show.

Primary: 0;;0;
Secondary: ;0.00;0;

see attached.

cheers,