I am having difficulty with a graphing macro. The macro was written for Excel 2003; however, I am now using the program on Excel 2007 and some of the features do not function in 2007. The macro was written to make trendlines of a certain set of data, there used to be an option that would allow you to choose the color of the trendline as well as the type of trendline you wanted (ie linear, polyfit). Can anyone help me figure out what may have happened and a possible solution?
Thank You
Hi,
You'll need to post the macro that you say isn't working.
Trendlines can be changed to a different type and of course the colour can be varied.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Here are the subroutines and functions. I didn't write the macro, so I'm not 100% sure what's going on. It seems as if chosing what type of trendline is working, but I'm not sure how to handle the part where it asks what color you want it to be.
Thank You
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
Hi,
In your TrendALineAuto procedure include code like the following. I've also included the trendline weight and style. Just delete if not necessary.
Please Login or Register to view this content.
Is there anyway to get the macro to pause at the format trendline screen so that I can manually choose which line fit I want and then choose which color I want manually? The biggest thing I am doing is I am updating about 30 plots and I do not want to have to manually go in and add a trendline and then format it by hand. I want to be able to just have one "Format Trendline" box, where I can select the line fit and the line color/style, that will update all the plots with the trendline I have selected.
Thank You
Last edited by mgphill; 08-01-2012 at 08:29 AM.
Hi,
Perhaps the easiest way would be to have a couple of Data Validation drop down cells, one containing a list of trendline types and the other a list of colours. Then read those cell values in the macro rather than have them hard coded.
Regards
If you step through the macro step by step, the following lines display the "format trendline" screen. I was wondering if I'd be able to just select the desire items in that screen and then have those apply to all the plots. Do you think that could work?
Thank You
Please Login or Register to view this content.
Hi
If I understand your request to be to capture the trendline type and then use that on all chart objects on a sheet then something like the following.
Please Login or Register to view this content.
Is there a way to pause the macro so I can select the features I want from the "format trendline" screen? Like could it pause until I have selected the stuff I would like and then I could press enter to have the macro continue? Thank You
...have you tried the code?Originally Posted by mgphill
That's exactly what the line
Application.Dialogs(xlDialogChartTrend).Show
does.
That is what brings the dialog box up, but when I just run the macro, that box doesn't stay up long enough for me to click what I want.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks