Hello friends,
I have this cool script which changes multiple series widths on a line chart based on values specific for each series. Can I ask you to help me add the possibility to color each line according to the integer assigned to each series? I need to set the color of each line based on similar row of integers - 1 (for red), 2 (for blue) I have attached the workbook.
hopefully this is possible.....I understand I need to set the color with rgb?
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
if that works that is the most beautiful code I have seen !))) let me check!
I understand this is a separate macro to the first one which changes line thickness?
just run this macro - shows element not found and when I press debug - excel crashes - can you please check? Can I specify exactly which integer is assigned which color in the macro? - eg 1 is blue?
also do think this this macro can be merged with the weights adjusting macro? or it is better to keep them separate?
Last edited by zealot; 11-11-2020 at 02:07 AM.
Here is an alternative
Please Login or Register to view this content.
nice let me check
By the way, Andy - this is a separate macro right - do you think it can be combined with the thickness macro?Originally Posted by Andy Pope
It actually works!!! - this is what i call beautiful programming!)
maybe this can be an overkill but can this macro be updated to color the background of any data labels for each series that are present on the chart with the same color as the line?
Please Login or Register to view this content.
that is really amazing - this will go through all data points? can it be made to run only through the existing points? thanks a lot!
It goes through all data points and formats those that have a data label, hence the use of HasDataLabel within the For Each loop.
Dear Andy - thank you for your generous help - I noticed with the last macro it can only update labels which have no background -fr some reason it does not update background of the label when I run the macro again - can you please take a look?
You need to post an example file.
I tested on your original file by adding data labels to series 1 and data label to last point of series 2
it works - just had to enable visibility of all overlaying charts- please take a look at the chart Andy
https://www.temporary-url.com/4F87A
I think I have 5 or so charts overlaying each other - can you recommend an easy way to export all the charts once one to a predefined png file (file name will be in cell a1)?
There is no simple way to export images from excel.
You could copy the grouped charts to powerpoint, paste as image and then export from there.
Or do a screen capture and tidy up in paint, or some other image editor
Thank you Andy - maybe you have seen a way to quickly export Camera view to png file? the camera woudl render all overlaid charts as one image and it can be exported this way
I have attached the workbook which has two objects - chart and camera picture referencing this chart - maybe you can recommend how to export the camear picture as the png file? The png file name should be taken from a cell - eg. image1..if you wish I can create a separate topic for this question.
Last edited by zealot; 11-12-2020 at 07:13 AM.
There is no native picture export in excel.
One way is to use a chart object to hold the image and use the Export method of the chartobject
There is code example in this
https://andypope.info/vba/gex.htm
I see - thank you - wanted to ask if there is a way to change picture name based on a cell value?
also - can your addin be invoked by a keyboard shortcut?
If your chart was a single chart, rather than 5 stacked on top of each other you could simply use the export method.
You don't need to use the addin but you can make use of the code inside it to create your own routine.
You can name the chart object
Please Login or Register to view this content.
thank you Andy - can I name the camera image object?
Yes you just need to be able to identify the shape and then change it's name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks