hello, I'm working on a conveyor belt coupon tracking and I use a classic tracking sheet (pic attached). Is it possible to create a chart in an oval ring fueled by a table of Excel data?
hello, I'm working on a conveyor belt coupon tracking and I use a classic tracking sheet (pic attached). Is it possible to create a chart in an oval ring fueled by a table of Excel data?
Probably best draw with shapes or a picture. Both of which can be placed within a chart object.
What parts of the graphic would change based on your data?
If it's the text then that could be done with xy-scatter series and data labels linked to cells.
If it's the shading of segments on the track that is a little harder. You could create custom data markers to match the segment and again use xy-scatter to position markers. If the colour changes to more than 2 colours you will need a series for each colour.
thank you for your responsiveness,
To clarify my request, you will find attached the work file.
I want to create oval ring chart instead of circular ring
There is no built in chart that will create an oval.
As I said you will need to create it your self using shapes or a xy-scatter chart with custom markers.
You have not explained what it is about the data that you want to show.
Do the lengths change?
Do the colours change?
Do the descriptions change?
The best approach is dependent upon what is changing.
If the lengths change then shapes and VBA code will be needed.
if it's just text then a charts data label maybe sufficient.
If you use a chart it will need to be a xy-scatter where the data markers are custom shapes. You will need to create the custom shapes, apply them as markers (single data point at a time)
and work out the x and y position to make the oval shape.
Hello andy pope,
Actually the change is by length and color.
The the only way would be VBA and shapes.
Those on the curved section will be the hardest but you should be able to use Arc's
Thank you very much, this is a chance to start learning vba first.
I would start with doing it manually to make sure you get the effect and control over it that you need, before worrying about learning VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks