how to plot a graph in excel with 3 variables

Either option 2 or 3 above are still good, or you could consider a Bump Chart (can be created as a Line Chart in Excel). You appear to have 5 data series (for each pH level), each with two values (30 and 60 seconds). Present these in an array and they'll allow for easy comparison.ĮDIT: After considering the description of your data more, I don't think a Bubble Chart is a good option. Create a series of Scatter Charts that are identical (in scale and formating), but only vary based upon one of your variables (e.g.

This is probably better for categorical data. Scatter Charts can be used similar to a Bubble Chart, but with multiple series or data points encoded by color or shape. This builds in a problem similar to Pie Charts in the difficulty of interpreting and comparing the relative areas of circles. You have three relatively good options for charting three variables, but you'll need to play with your data to determine whats best for the story you're trying to tell.īubble charts use the basic layout of an XY or Scatter Chart, but allow you to encode a third variable in the data point's size. There's too many reasons to list here, but this blog post by Jon Peltier is worth a good place to start.

First, I would absolutely stay away from the 3d chart options.

How to plot a graph in excel with 3 variables