Chart with 3 different values

[Excelwig]

Hi

does anyone know a way of charting 3 different data formats

I have Number, %, and time that I want on one chart, I can only use the combo chart to do 2 not the 3

Can anyone help?

 

[Gerald Higgins]

Hi, you can do 3 on the same chart, but you'll need to compromise somewhere.

Consider charting not the actual data, but indices of the data, starting all data at 100 ?
Then you can easily chart any type of data.
You'll need formulas to calculate the indices.

OR, if two of your data sets happen to have similar numbers, select those two for plotting against one y axis, and plot the third set against the second y axis.