I have two questions, the first and more general question is: Are there any good resources (i.e., websites) that discuss more intermediate to advanced charting topics? (any that happen to touch on my next question would be specifically helpful).
Second question:
I am in a situation where i will be making MANY frequency charts. They should all be very similar except that they will use a different column of data and have a different name. Is there a way to easily adjust the source data without going through the process of right clicking, selecting source data, editing each element that needs to change.
can indirects be used in charts?
thanks in advance
Josh
Resources,
http://peltiertech.com/Excel/chartlinks.html
Manually you can select the series and then reposition the bounding areas over different ranges.
You can not use formula directly but you can use named ranges.
There is always VBA to speed up repeative tasks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks