macro to draw a vertical line on a graph

**kbaruin** · 10-05-2012, 11:08 AM

I have an issue drawing a vertical line on graphs that changes dynamically as per the data on their respective pivot tables. The line should be on or next to 15-20 range. Please see the attached spreadsheet. The range might or might not appear in the chart. But the line should always be on or after 20.

I have 3 charts on the same spreadsheet that needs a line. I have come across a code on internet, but donno how to edit for my case here.

Please Login or Register  to view this content.

Please kindly help.

Many Thanks and Kind regards

**Andy Pope** · 10-05-2012, 11:23 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Your main problem is the code is for a Date axis and you have category axis.
This will add line after 2nd category.

Please Login or Register  to view this content.

**kbaruin** · 10-05-2012, 11:31 AM

Andy

Sorry edited my post. I tried your code but doesn't work. It just adds a dotted line on all the charts but not on the 20 line.

Please can you help with the code.

Thanks
Bhargavi

**Andy Pope** · 10-05-2012, 11:38 AM

What's the 20 line?
As I said your axis is not a value axis, it is category.

You would need to decipher the axis labels in some way in order to determine the numeric value of a individual category.

**kbaruin** · 10-05-2012, 11:43 AM

It is actually a value but I grouped the column to show a range on the chart. You can see its Pivot table. I want the line to be displayed at 20 days so that the graph shows all the ABCs thats generated after 20 days needs concerned. I manually added a red line on the charts, that is how I wanted but by macro code.

Your code just adds a dotted line after 2nd categery irrespetive of how many days. Is it possible to get how I wanted??

Thanks

**Andy Pope** · 10-06-2012, 07:36 AM

Please Login or Register  to view this content.

Some of the lines will be pretty meaningless as the value does not exist on the chart.

**kbaruin** · 10-08-2012, 03:23 AM

Andy

Thanks Very much. It works as I wanted. Just one last amendment needed. Can this be Red color line and a bit thick line please???

Thanks again

**Andy Pope** · 10-08-2012, 04:35 AM

Can you not try using the code you had in the first post to format the line?
The routine has a variable, shpLine, that references the line on the chart.

**kbaruin** · 10-08-2012, 05:08 AM

Andy

I tried the code in your last post which works fine. Can you point me where to change in the code for the color and thichkness of the line?? I am not sure where to change for the shpLine.

Thanks

**Andy Pope** · 10-08-2012, 05:12 AM

Please Login or Register  to view this content.

**kbaruin** · 10-08-2012, 05:55 AM

Hi Andy

Is there a way where I can choose which charts to have the line??

Thanks

**Andy Pope** · 10-08-2012, 05:59 AM

probably.

Currently the code loops through all the chart objects on a sheet.

Please Login or Register  to view this content.

You just need to specify what chart object to pass to the AddDatum routine.

**kbaruin** · 10-08-2012, 06:14 AM

I want the chart 13, chart 14, chart 15 on the sheet to have the line, how do I state this in the code??

**Andy Pope** · 10-08-2012, 06:15 AM

not really putting much effort into this are you

Please Login or Register  to view this content.

**kbaruin** · 10-08-2012, 06:28 AM

Type mismatch error
I am a VBA beginner and your code is very complicated to understand.

thats why need your help in editing

**Andy Pope** · 10-08-2012, 06:33 AM

But you are not showing us any of the stuff you are doing. You just keep on asking for more and more, including editing of stuff that has already been posted.

Take your last post, you have not shown the code you used, you have not said where exactly the error occurs.

**kbaruin** · 10-08-2012, 06:46 AM

Sorry about that. I am trying to call the AddDatum function for only charts that I wanted the line. The error occurs at the 3rd line.

Please Login or Register  to view this content.

**Andy Pope** · 10-08-2012, 06:48 AM

Oversight on my posted code.

Please Login or Register  to view this content.

**kbaruin** · 10-08-2012, 06:57 AM

Thanks ever so much Andy. It works now.

Apologies for too many questions.

**Andy Pope** · 10-08-2012, 07:01 AM

Glad to hear it

macro to draw a vertical line on a graph

LinkBack

Thread Tools

Rate This Thread

Display

macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Re: macro to draw a vertical line on a graph

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions