Swap columns with rows in chart
-
I created a table where the columns are the names of the values, and the rows are the values. But when I create a chart in the legend values of columns, not rows. That is, I need to swap the series and the legend in the chart. How do I do this?
-
Hi Artyom,
Sorry for inconvenience,
You will need to create different structure of your table to make this happens. So first column will be string type column and data from this column(data from rowsof this column) will be used for creating x-axis in the chart. All other columns have to be integer or floats so next column will be named row1(you will call it for your needs and it will contain numbers from first row from your initial table, next will be row2 with numbers of second row from your initial table…)
String column row1 row2 row3
col1name 5 6 7
col2name 1 2 3
col3name 11 20 11Like this you will get chart like you need.
Best regards
- The topic ‘Swap columns with rows in chart’ is closed to new replies.
