G
g_malkani
Hi
I have around 400 rows that I have filtered by location (around 100) so
I need a 100 graphs, one for each location. However, I used a filter
to change the graph which works except for the title which is the
location and it does not seem to change at all although i gave it a
cell reference (tried absolute and relative). Is there anyway that the
chart title can change everytime i apply a different filter? If there
is a way please let me know?
Also, I wanted to add in another column (which contains a percent of
the value) into my chart so it displays the value and the percent as
well, so I created another series to be added into the graph and then
showed no line and no box so it just displays the percent. However, by
doing this, it takes away the previous Chart title that I had. Is
there a way of fixing this as well?
Thanks for any help that u can give me
I have around 400 rows that I have filtered by location (around 100) so
I need a 100 graphs, one for each location. However, I used a filter
to change the graph which works except for the title which is the
location and it does not seem to change at all although i gave it a
cell reference (tried absolute and relative). Is there anyway that the
chart title can change everytime i apply a different filter? If there
is a way please let me know?
Also, I wanted to add in another column (which contains a percent of
the value) into my chart so it displays the value and the percent as
well, so I created another series to be added into the graph and then
showed no line and no box so it just displays the percent. However, by
doing this, it takes away the previous Chart title that I had. Is
there a way of fixing this as well?
Thanks for any help that u can give me