- #EXCEL FOR MAC GRAPH TWO VERTICAL AXES HOW TO#
- #EXCEL FOR MAC GRAPH TWO VERTICAL AXES SERIES#
- #EXCEL FOR MAC GRAPH TWO VERTICAL AXES DOWNLOAD#
In the Format Data Series dialog, choose Axis > Secondary axis.
Then select the series again like you did before (it doesn’t stay selected for maximum frustration value) and press Command-1 to pull up your formatting options. Then click OK.Ģ011 (Mac): With the Conversion Rate series selected, choose Charts tab > Change Series Chart Type > Line > 2-D Line > Line. And put it in a secondary axis by selecting that option. Then, in the Change Chart Type dialog, set Conversion Rate to Line from the drop-down. To change the chart type to a line chart, I’ll break out the processes for 20 separately since the steps for the Mac are so different.Ģ013 (PC): With the Conversion Rate series selected, choose Design tab > Type > Change Chart Type.
#EXCEL FOR MAC GRAPH TWO VERTICAL AXES DOWNLOAD#
But then, all you have to do if you’re following along with the download is: with the chart selected, choose the new series by going to Chart Tools > Format tab > Current Selection > Series “Conversion Rate” (2011: Charts tab > Format tab > Current Selection > Series “Conversion Rate). It won’t look amazing because we’re pasting in a value that’s less than one. One super cool trick to adding a new data series to a chart you’ve already created is to just select the column, copy it, select the entire chart (you’ll see the whole chart outlined), and then paste it in. I changed the Revenue series back to a column chart to decrease chart junk. Let’s say we want to also add conversion rate to the chart. With my dataset, I’m just going to select the Visits and Revenue columns since I have an extra column for conversion rate.Ĭlick for larger image Adding A Secondary Axis Step 2: Click any cell inside your dataset and go to Insert > Charts > Insert Column Charts > Clustered Column (in 2013 on the PC) or Charts > Column > Clustered Column (in 2011 on Mac). (I also always format my data as a table.) Step 1: Have a dataset with at least the two values you want to chart. If you’d like to follow along, feel free to download the Excel doc I pulled all my screenshots from. Some classic metrics I use frequently in combination charts are: The reason is that they give you the ability to demonstrate data trends visually.
#EXCEL FOR MAC GRAPH TWO VERTICAL AXES HOW TO#
It’s embarrassing to admit this now, but I had no idea how to do that - or that you even could combine totally different metrics like that. (Disclosure: I am not affiliated with MarketMotive in any way.) When I took MarketMotive’s analytics certification course, in my dissertation, Google Analytics evangelist Avinash Kaushik asked me why I didn’t show visits and bounce rate together in the same chart. The first skill we’re going to focus on to that end is how to create a combination chart. (Editor’s note: This popular series continues on Marketing Land with Creating Sexy Charts In Excel!) Why Use Combination Charts? It’s going to be a long series - but by the time we’re finished, you’ll be able to create dashboards that excel in both form and function. I’m starting a series on dashboards because I think creating sexy dashboards is a critical skill every marketer needs to know.
0 kommentar(er)
