Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Impossible - Dynamic Legend?
Hi,
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 chart 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 chart and legend? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to place a legend inside a legend | Excel Discussion (Misc queries) | |||
Zero values not legend, Value grater then zero show data and legend | Excel Discussion (Misc queries) | |||
Dynamic legend labels | Charts and Charting in Excel | |||
Dynamic legend/series | Charts and Charting in Excel | |||
Automation of Dynamic Chart Title and legend changes | Charts and Charting in Excel |