Hi All,
Hopefully this isn't too difficult a question....
I have data in spreadsheet, with months in row five from C to BJ. In the subsequent rows below are different products sales over time. I would like to graph the data, however the number of products varies depending on a user selection. Is it possible to make the graph only show the correct number of products ? For example there are 4 red products, so the graph would have 4 series' on it one for each product.
Any help would be gratefully received.
Thanks
Dan
Hopefully this isn't too difficult a question....
I have data in spreadsheet, with months in row five from C to BJ. In the subsequent rows below are different products sales over time. I would like to graph the data, however the number of products varies depending on a user selection. Is it possible to make the graph only show the correct number of products ? For example there are 4 red products, so the graph would have 4 series' on it one for each product.
Any help would be gratefully received.
Thanks
Dan