hi fellows,
trying to visualise sales performance in different countries following this table... and I just puzzled with making it in multiple series, so the countries could be visible on the chart as a series name. please advise!!
axis y should be number of sales
axis x - turnover
country - series name
many thanks in advance
Andrey
OS X Mountain Lion (10.8.5)
I wasn't able to do something like what you describe, but I was able to do this:
I defined column A of the table as a Header Row, selected the cells in the table, and chose this chart type (2D 2 Axis):
Then I clicked the chart and in the pane at the right checked 'Axis Name' in the Axis tab and added the axis names.
Maybe this can give you an idea of how you can illustrate the relationships that you want to show.
SG
I wasn't able to do something like what you describe, but I was able to do this:
I defined column A of the table as a Header Row, selected the cells in the table, and chose this chart type (2D 2 Axis):
Then I clicked the chart and in the pane at the right checked 'Axis Name' in the Axis tab and added the axis names.
Maybe this can give you an idea of how you can illustrate the relationships that you want to show.
SG
creating a chart with multiple series - help needed
