Forum Discussion
Create chart with 2 axes: % and value
I have a table where some values are expressed in hours (for example 8h), and some others are in percentages. The rows are KPI names, and the columns are weeks. I figure I need a combined chart with two axes, one for the hours and one for the %, but when I make a combined chart, it doesn´t place the weeks along the X axis (even after flipping row/column), and oddly enough, the chart is not even listing all the values in the rows. Any ideas?
Ber93 Your picture doesn't say very much, but I tried to replicate the type of graph I think you want to create. Have a look at the attached file and see how it has been set-up. Compare it to your own file and hopefully you can make the necessary changes.
1 Reply
Ber93 Your picture doesn't say very much, but I tried to replicate the type of graph I think you want to create. Have a look at the attached file and see how it has been set-up. Compare it to your own file and hopefully you can make the necessary changes.