Hello and good morning,
I need to create 69 charts with 4 different series in every chart displaying information like average stock growth and so on. Is there any smarter way i can do that than manually when i know that the range of these charts will be consistant?
Thanks in advance,
Joachim
None have any sweet macro or something to solve this problem?
Do you really need all the charts? Can you not use 1 chart and alter the data displayed?
You really need to post example file so we can see your data layout and chart formatting, otherwise any generic code will no doubt result in a response of "It does not work for my data" or "How do I change it for my data".
Yes you're right, sorry. In this example, sheet 2 has the input data that=1 graph, the format of the graph you can find on sheet 1.
And to answer your question, I need separate charts as they are going to be used in Word documents that goes out to clients.
Last edited by Joachimjr; 06-30-2014 at 08:56 AM.
This will create a chart with data.
Please Login or Register to view this content.
You can use the macro recorder to get formatting and trendline additions.
Very nice thank you! Will this macro create multiple charts from the range that I start it? And also, can it create the little graph that uses the last column data?
You would need to extend the macro to do more than 1 chart. But your workbook example did not include any indication of where things should be extended, Actually the example file did not even use the data in the workbook as it was all linked back to your original files.
This creates single series chart under 1st. Then repeats using columns F:H and I keeping catergory based on column A
Please Login or Register to view this content.
Oh, Sorry for that. I will change it and I will also change the smaller graph.Example of Charts.xlsx
Very nice! Thank you very much! So now if I want to start making graphs from GX7 for example, I just change "A7" to "GX7"? And also, is a macro recording best for automatically change the data series names?
The macro recording is best for getting the syntax. You will need to change it in order to incorporate in loop.
If you had included the series names on the worksheet and chart I would have included in code.
The data series name is included in the "code" row of the sheet that is generated from datastream. Is there anyway that one can implement that in the code?
Please Login or Register to view this content.
Instead of having code as a name of every series, could one change something in the Code to name the series "Index", "50d moving average" and "200d moving average" so it will also be a fixed name for every chart created?
Please Login or Register to view this content.
Thanks for everything Andy! You helped me saving loads of time and minimizing the window for error in manually choosing range for every individual graph!
Please Login or Register to view this content.
When I apply this code to my worksheet, I the the Compile error: Can't find project or library, why is that?
Is Datastream the code name of a worksheet?
Did you really mean to add chart objects to chart sheets?
Whats Daily?
Check references in VBE for missing references.
Yes I solved the compile error, Datastream was not the correct code name, it was Sheet4. And for "CHARTS (Daily)" it was sheet1. But now when I use the macro, the charts come out incorrect. Have I changed something in the code that shouldn't be changed?
Charts is the collection for chart sheets.
Would have saved a whole bunch of time and mucking about if you had posted usable example in the first place.
I'm sorry my friendI'm not that good at VBA and therefore not particularly good at posting a solid example.
Here is how the code looks right now
Please Login or Register to view this content.
You don't need any VBA knowledge to post a workbook.
I'm sorry but I thought I posted that which was needed to create a code. And I'm also not allowed to post most of the things that I work with. Therefore I like to keep the things going out from the computer to a minimum.
But your example file is not like the one you are actually working with.
For a start the code names of sheets does not tally and that is one of the things causing you problems.
Sorry, but I'm stepping out of this thread now.
I thought that it would be easy fixable by just chaging the name of the sheets
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks