Unfortunately, there isn’t native functionality to create one, but we can fake an Excel graph with 3 variables by creating another data series with a constant x-value, like I’ve done in the image below. So he wanted to know if there was a way to create a 3 axis graph in Excel. This makes it hard to view the acceleration curve on the chart without a unique axis. The challenge is that all three curves have very different scales, with acceleration being the smallest. I’ll show all the steps necessary to create an Excel graph with 3 variables below.
Multiple y-axis charts in Excel are straightforward if you only need to plot 2 y-axes but 3 y-axes take some more work and a little creativity. The industry-standard way of graphing this data is to include all three curves on the same chart, like in the image below, and he wanted create one like it in Excel.
He uses Excel to create charts of cam position, velocity, and acceleration. Ever wanted to know how to create a 3 axis graph in Excel? The other day I got a question from Todd, an subscriber.
0 kommentar(er)
