L
LiAD
Morning,
I have a table of 23 rows (products) and 30 columns (date) which plots sales
of different items against the date against which they were sold. Not all
products are sold every month. Using macros I can create the table that will
summarise the sales per day in a particular month for any items that were
sold, deleting all empty days and product lines. So my table can be anywhere
from a 1x23 to a 23x30. I would like to create a dynamic graph that will
plot the date on x-axis against the sales per day on the y-axis WITH THE
LEGEND SHOWING WHICH PRODUCTS WERE MANUFACTURED. As the chart depends on the
table my graph can have 1 to 23 lines on it, with 1 to 23 items in the
legend. My table starts in cell AP5.
How can I create such a dynamic graph that will also update the legend?
Thanks
I have a table of 23 rows (products) and 30 columns (date) which plots sales
of different items against the date against which they were sold. Not all
products are sold every month. Using macros I can create the table that will
summarise the sales per day in a particular month for any items that were
sold, deleting all empty days and product lines. So my table can be anywhere
from a 1x23 to a 23x30. I would like to create a dynamic graph that will
plot the date on x-axis against the sales per day on the y-axis WITH THE
LEGEND SHOWING WHICH PRODUCTS WERE MANUFACTURED. As the chart depends on the
table my graph can have 1 to 23 lines on it, with 1 to 23 items in the
legend. My table starts in cell AP5.
How can I create such a dynamic graph that will also update the legend?
Thanks