Unanchor Chart Series

[SZBELL]

I have created a sheet which shows sales data on each row. I want to show a graph for each row but, i do not want to have to manually change the data each time i copy the line down. any suggestions?

[dilipandey]

Hi Szbell,

You can use defined name as a data source to chart. Upload a sample workbook if sound interesting. Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[SZBELL]

thanks for the response! i have attached an example sheet. Note: the highlight cells will be in directs, allowing me to "pull" the rows down.

[dilipandey]

Both the charts are having same data source

Can you provide an explanation in relation with attached workbook which clears your expectation ?

Regards,
DILIPandey
<click on below * if this helps>

[SZBELL]

the light pick highlights are to explain that those cells values are indirect functions from another sheet. each indirect will provide a new set of sales data. . i would like the second graph not to be linked the previous graphs data. so i can copy the graph down many times.

[SZBELL]

DILIPandey, do you understand what I'm trying to explain and achieve? thanks again.

[dilipandey]

yes... can we have a dropdown values per table... like 1 in first table, 2 in second table as based on these numbering I can try offsetting defined names to suit every new chart.


Regards,
DILIPandey
<click on below * if this helps>

[SZBELL]

Great! Will you be able to show me this on the previously attached sample sheet?

[SZBELL]

did you give up on me?

[dilipandey]

No
our timings not matching

So what is your response to my query in post#7 ?


Regards,
DILIPandey
<click on below * if this helps>

[SZBELL]

Can you show me an example, i having trouble imaging. Thanks

[dilipandey]

Okay.. now I understood that I was thinking on some different line.
For you query, please refer to the below link:-

http://peltiertech.com/WordPress/mak...k-to-new-data/


Regards,
DILIPandey
<click on below * if this helps>

[SZBELL]

Solved! i just created a code to just through each chart and change the series.. Thanks Dili for all the help!

Please Login or Register  to view this content.

[dilipandey]

you are welcome


Regards,
DILIPandey
<click on below * if this helps>