Help in creating a chart

[leontin]

Hi, guys. I'm pretty new to excel and i'm struggling to create a basic chart like in the image.
Can anyone help me with a video\tutorial or something to create this? I guess it's not complicated to do.
I have searched on the internet buy i couldn't find something similiar. I guess it will be a combination of doughnut with pie chart?

What i want is up to six pointers\lines, eache one of them coresponding to a value in a cell.
Example: cell: A1=25, A2=6 etc and i need pointers in the circle to match the value in the cell with the number in the circle and if no value in the cell then no pointer.

Thank you in advance.

 

[leontin]

Ok, I don't know what aspect of your code this relates to but maybe try this approach.
Can you define the the ranges in question as Named ranges? That way, Excel will keep track of them as and when you insert or delete.

Then within the vba code, refer to the ranges by Name rather than reference.
Eg Named range in Excel for I10 is "Rotation"
Refer to it in vbs as Range("Rotation") rather than Range("I10") and it will hold good if insertion causes I10 to become J10

Wow, that really worked :D and it was so easy. I didn't think that I can define a named range for a single cell. Thanks for the tip!