cwolfe8229
New Member
- Joined
- May 29, 2007
- Messages
- 29
I have a basic line chart. Under Source Data I call: =Summary!$A$5
That cell is: =B1&" Loaded" where B1 is a number used as a reference to call a row of specific data to update my chart for that work center.
Whenever I change B1, my data and my chart update perfectly, the legend does not, so when I publish my charts, the legend always shows the wrong work center.
How can I force the legend to update? or else, can I create a Title block that references a cell contents directly (thus eliminating the need to change the legend title)
Thank You
That cell is: =B1&" Loaded" where B1 is a number used as a reference to call a row of specific data to update my chart for that work center.
Whenever I change B1, my data and my chart update perfectly, the legend does not, so when I publish my charts, the legend always shows the wrong work center.
How can I force the legend to update? or else, can I create a Title block that references a cell contents directly (thus eliminating the need to change the legend title)
Thank You
