Hui,
Back in 2019 you demonstrated the solution to a charting problem I had been attempting for many years. "pct_circle_chart". Back in 2009 I was going to bore and stroke the engine in my modified Jeep Cherokee and wanted to build it in Excel before doing so physically. Many years ago, builders talked about Compression Ratios, and while a good reference, I had learned about dynamic Compression Ratios that are affected by Camshaft selections with all other components remaining constant. Wanting to retain the ability to continue using Regular gasoline, I had to stay within certain criteria.
So after hundreds of hours of work, I have a reasonably good Jeep Engine Build Calculator as long as you want to build a Jeep 4.0 Liter I-6.
Most Tabs are Protected because of the time I've spent on developing this, but the first Tab "Engine Build" is not, and it is the one I have a question with. On the right side of the sheet is an image of the Valve Timing for a specific Camshaft. I have dynamically charted the timing with both the donut chart to the right of the valve timing events, and the spider chart to its right. I would like to over lay the spider chart on top of the donut chart, but when selecting a different Camshaft, the length of the arms change ruining the appearance. If possible, I would also like to display the "degree" number at the end of the arms for the specific event.
The file is too large at the moment, so I'm going to try to pare it down to a size that I can upload... Even with only required Tabs remaining, the file is too large; 1.5 MB. Zipping did little to reduce the size. Is there a way to get the file to you to look at without uploading it here on the forum?
Best Regards,
Mark