change chart series to secondary axis

[sebbyp]

Is it possible to move a time series to a secondary Y axis as in excel?

[v-micsh-msft]

Hi sebbyp,

Currently I don’t think this is possible.

Secondary Y Axis currently is only available under combo chart, when put time values, combo chart would automatically change it into count values.

By the way, could you please share more information regarding the reason for putting time series into secondary Y Axis? Maybe we could offer some additional workaround.

Regards

[sebbyp]

My data set contains values which are measured in different units for example percentage, in millions, in billions, whole number.  But the values all fall within one column for the entire data set with a separate column describing the unit.  In order to compare the different time series to see if there is a relationship i would normally (in excel) send a time series to a secondary Y axis.

I have tried the combo charts but i have learnt that these only allow comparison of columns on a specific time series.

[sebbyp]

Is there any more news on this.  Really missing this functionality and is something that has been available in Excel for a very long time.