Hi
I welcome any solutions for this problem:
I have approx 270 line items. Each line item has a geographical location and a business sector attributed to it, which are represented by two numbers (location = 1-7 and business sector = 1-7). These numbers have previously been used to create a matrix, with the assets having a point plotted on the matrix based on these numbers.
My boss wants a matrix next to each line item, which I think would mean approx 270 matrix graphs/charts in the document (which I assume will make the file big GBs). Is there another way to plot a matrix like this?
Secondly,I'd like to format the point on the matrix a different colour dependent on the numbers (eg 5, 6 and 7 would be red, 3 and 4 green etc). Is this possible?
Thanks
I welcome any solutions for this problem:
I have approx 270 line items. Each line item has a geographical location and a business sector attributed to it, which are represented by two numbers (location = 1-7 and business sector = 1-7). These numbers have previously been used to create a matrix, with the assets having a point plotted on the matrix based on these numbers.
My boss wants a matrix next to each line item, which I think would mean approx 270 matrix graphs/charts in the document (which I assume will make the file big GBs). Is there another way to plot a matrix like this?
Secondly,I'd like to format the point on the matrix a different colour dependent on the numbers (eg 5, 6 and 7 would be red, 3 and 4 green etc). Is this possible?
Thanks
