Charting isn't my strong point at the best of times but I'm having trouble using the bubble chart.
An image of
my sheet is here.
Here is the workbook: https://www.dropbox.com/s/q6054aru8e7mj1f/bubblecharttest.xlsx?dl=0
I can't seem to get all 3 values in each row to be used in the chart. Instead, the position of the row in the table seems to be one of the values in the plot (it's being used as the xvalue) please see the second chart.
Also I can't get the chart to use the row names to label the bubbles. I tried including the company name column in the selection before inserting the chart and it's only plotting 2 bubbles instead of 4.
Any ideas what I'm doing wrong?
An image of
Here is the workbook: https://www.dropbox.com/s/q6054aru8e7mj1f/bubblecharttest.xlsx?dl=0
I can't seem to get all 3 values in each row to be used in the chart. Instead, the position of the row in the table seems to be one of the values in the plot (it's being used as the xvalue) please see the second chart.
Also I can't get the chart to use the row names to label the bubbles. I tried including the company name column in the selection before inserting the chart and it's only plotting 2 bubbles instead of 4.
Any ideas what I'm doing wrong?
