This data has two datasets,e Sales and Target Achieved %. How to Add a Secondary Axis in a Google Doc Spreadsheet Step 1: Gather your data into the spreadsheet.. Make Row 1 your X-axis and Rows 2 and 3 your two Y The last line throws the Exception, if no actual data are not connected to the axis. Expand your knowledge and take control of your career with our in-depth guides, lessons, and tools. Compared to the first version of this chart, adding a second axis makes it much easier to compare the trends. Click the line graph and bar graph icon. 3. You can also change the alignment and orientation of the labels, and change or format the text and numbers that they display, for example, to display a number as a percentage. Select "Series 'Percent of Nike Shoes Sold'" -- or whichever you want your secondary axis to be. Level up your tech skills and stay ahead of the curve, A quick guide to adding a secondary Y-Axis to a bar or line graph in Microsoft Excel. What do gun control advocates mean when they say "Owning a gun makes you more likely to be a victim of a violent crime."? Include your email address to get a message when this question is answered. Click Add Chart Element > Axes > More Axis Options. The data has Month in the first column and Sales and Sales percentage in the second and third columns, respectively. By selecting an element on a chart, theChart Toolstab will appear in the ribbon. (And for even more Excel tips, check out our post about how to use Excel.). In fact, charts that can reveal hidden insights into the relationship between two different variables are limited. You can also change the amount of space between levels of labels on the horizontal (category) axis. So, we can change the chart type by going to Design > Change chart type. why does music become less harmonic if we transpose it down to the extreme low end of the piano? However, sometimes, it returns a run-time error on the last With command, on the .Axes(xlValue, xlSecondary).HasTitle = True at the end of the code. However, the application does not natively support the 6 chart variants with a secondary y-axis. Learn how the long-coming and inevitable shift to electric impacts you. How does the OS/360 link editor create a tree-structured overlay? Excel Dual Y Axis (one on top of the other) 2. Click the type of axis that you want to display or hide, and then click the options that you want. You'll just need to create the base chart before you can edit the axes. 3. Between May 24th and May 31st, conversions were directly proportional to impressions. Luckily, this can be done in a few simple steps. Or does it force you to stop and is expecting you to fix something? In the Format Data Series window, select the Axis tab and then select Secondary Axis.. This article was co-authored by wikiHow staff writer, Rain Kengly. We use cookies to make wikiHow great. 3: Hover "Axis Titles" to get the black arrow point to the right and then select the option Spaced paragraphs vs indented paragraphs in academic textbooks. We discuss adding a secondary axis in Excel, a practical example, and a downloadable Excel template. select the Format data series option. I have the vertical columns for the first set of data, but how do I add the horizontal axis for the next set of data? 1. Select the first line graph option that appears, as shown below. Try another search, and we'll give it our best shot. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. But whenever I try to move one series of data on secondary axis, the chart automatically overlaps the two bars. Similarly, there could be another visualization that allows you to add multiple y-axis so that you can better explore your results in a single visualization. Learn how to create data for Excel charts and create insightful visual representations of your data with this easy-to-follow guide. Adjust axis tick marks and labels (Office 2010), Change the number of categories between labels or tick marks (Office 2010), Change the alignment and orientation of labels (Office 2010), Change text of category labels (Office 2010), Change how text and numbers look in labels (Office 2010). Your new data series will now be displayed in your chart, however it is presently being measured as a low-lying sequence of columns on your main Y axis. Asking for help, clarification, or responding to other answers. rev2023.6.29.43520. For example, xy (scatter) charts and bubble charts show numeric values on both the horizontal axis and the vertical axis. Essentially, you have to add a secondary y-axis Excel manually, which is time-intensive. However, sometimes, it returns a run {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/59\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-4.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/5\/59\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-4.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}. Example, before and after changing the axis: In the chart, click the horizontal axis, or do the following to select the axis from a list of chart elements: On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the horizontal (category) axis. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Click the bar graph icon in the "Format Data Series" window. Step 3: Create the Secondary Axis in Google Sheets. Having selected "Format," navigate to the dropdown menu on the top-lefthand corner of your menu bar, where it might currently say "Chart Area." Select the first option: 2-D Column. Now, well press Ctrl+1 to open the format data series options. This step applies to Word for Mac only: On the View menu, click Print Layout. How one can establish that the Earth is round? Now, you have two scales in your chart. Is it legal to bill a company that made contact for a business proposal, then withdrew based on their policies that existed when they made contact? Can renters take advantage of adverse possession under certain situations? Find centralized, trusted content and collaborate around the technologies you use most. Select the When it does occur, can you "continue" and the macro keeps running, as it should? See pricing, Marketing automation software. Making statements based on opinion; back them up with references or personal experience. 0. How to Read a Chart with Secondary Y-Axis in Excel? In the Select Data Source dialog box, under Horizontal (Categories) Axis Labels, click Edit. If both the data sets are important to show, we can use a secondary axis. The application generates super-advanced, ready-made, visually stunning graphs with a secondary y-axis Excel. You can view the primary axis value from the left side of the axis. Your secondary data series should ideally be presented in a different format than your columns. Besides, these charts come in 6 variants, namely: The main benefit of this group of charts is they spare you the time and effort needed to create two charts for the same data story. This will add a second Y-axis to the right side of the graph. Charts typically have two axes that are used to measure and categorize data: a vertical axis (also known as value axis or y axis), and a horizontal axis (also known as category axis or x axis). That's all! Asking for help, clarification, or responding to other answers. Now look at your chart. Click to learn how to create the best survey questions with higher participation rates. A secondary axis is used to compare two things that don't have the same unit of measure. Right-click on it. You'll see your new data series added to your chart, but currently, this data is being measured as a low-laying series of columns on your primary Y axis. For this example, Row 3 will be our secondary axis. Adding a secondary Y axis is useful when you want to plot multiple data series that are measured on different scales.HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)Screen recorder \u0026 editor https://techsmith.z6rjha.net/c/1988496/506622/5161YouTube SEO https://www.tubebuddy.com/SHTeach Software (Microsoft Excel 365 ProPlus)FOLLOW US Website https://toptipbio.com/Facebook https://www.facebook.com/TopTipBio/ Twitter https://twitter.com/TopTipBioAFFILIATE DISCLAIMERSome of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You dont have to add secondary y-axis Excel manually. They almost but don't quite line up, like your data. Using Dual Axis Chart First. To learn more, see our tips on writing great answers. To read and interpret a chart with a secondary y-axis Excel design, follow the easy steps below: Consider the order to use when plotting bars in this chart. 4. In TikZ, is there a (convenient) way to draw two arrow heads pointing inward with two vertical bars and whitespace between (see sketch)? How? In other words, this chart is convenient for uncovering hidden insights into the relationship between two or more measures with different scales and measures. As a small thank you, wed like to offer you a $30 gift card (valid at GoNift.com). Right Click in the Chart area. It helps me as well. Stick to making one point with your chart. In this example,it's Series "Employees.". By clicking Post Your Answer, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct. In the Axis label range box, do one of the following: Specify the worksheet range that you want to use as category axis labels. Is it usual and/or healthy for Ph.D. students to do part-time jobs outside academia? @Abiel I am glad you got it worked :D thanks for sharing your version. Below are the steps to add a secondary axis to an existing chart. Plot Data on Primary AND Secondary Axis. Not the answer you're looking for? Please note that for Excel 2007 charts have such a unfortunate cases with recording macros. Excel's charts give you a variety of ways to visualize your data. "Brilliant, thanks. Select Series 'Percent of Nike Shoes Sold' by clicking this option (or whichever series you want as your secondary axis). Click the chart, and then click the Chart Design tab. WebOn the Design tab, click the down arrow next to Add chart elements, and then hover over Axes in the fly-out menu . We recommend you label your chart with relevant titles and legends. Well, charts with a secondary y-axis are among those limited visualization charts (mentioned above). Once the add-in has been installed successfully, you will see a list of the charts available. First, select the line (or column) associated with the second data series. All tip submissions are carefully reviewed before being published. Adding a secondary axis is one of those advanced techniques in analytics. I created a variable cont3 that counts the number of Series for the secondary axis. After you select "Series 'Percent of Nike Shoes Sold,'" click on the "Format Selection" button -- it's right below the dropdown. Step 1: Make a Scatter Chart At first, you have to make a scatter graph with the available series of data. Under Series Options, choose Secondary axis in Plot Series On. We can add a dual axis, i.e. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free. 2. Apart from Excel, the Secondary axis can be added to Google Sheets, Power BI, Tableau, etc. Nurture and grow your business with customer relationship management software. In fact, visualization designs that can reveal hidden insights into the relationship between two different variables are limited. Connect and share knowledge within a single location that is structured and easy to search. Thanks for contributing an answer to Stack Overflow! You can adjust the way that they are displayed by using major and minor tick marks and labels. Set your spreadsheet up so that Row 1 is your X axis and Rows 2 and 3 are your two Y axes. Regards, You can change the format of text in category axis labels or numbers on the value axis. ChartExpo is an add-in you can easily download and install in your Excel app. Also, it is very similar to Word or Document. To add a vertical axis title, execute the following steps. Click on the second series, or select it from the Chart Elements dropdown on the Format tab of the ribbon (under Chart Tools). Those two sets of data have two Y axes with two different scales -- the number of leads and the conversion rate -- making your chart look really wonky. Both the data sets need to have two-axis in a single chart. We are switching over from the Primary Y-Axis to Secondary Y-Axis here. Type the labels that you want to use, separated by commas for example, Division A, Division B, Division C. NoteIf you type the label text in the Axis label range box, the category axis label text is no longer linked to a worksheet cell. Choose the account you want to sign in with. Create a spreadsheet. Login details for this Free course will be emailed to you. Click Edit under "Horizontal (Category) Axis Label" and click okay. Check the box for each line you want to add to the Y-Axis. Radar charts do not have horizontal (category) axes, and pie and doughnut charts do not have any axes. We will use Row 3 as our secondary axis in this case. How to Add a Secondary Y-Axis in Excel? Otherwise, you can highlight the data you want to include in your chart and click "Insert" on the top-lefthand corner of your navigation bar. The chart shows Target achieved % in a column bar with a secondary axis. Click to learn how to conduct and analyze short surveys for actionable insights. Then, on the far left where it reads "Current Selection," click on the dropdown that reads "Chart Area." By
% of people told us that this article helped them. How Bloombergs engineers built a culture of knowledge sharing, Making computer science more humane at Carnegie Mellon (ep. On the Format Axis pane, expand Tick Marks, and then click options for major and minor tick mark types. Next to "Percent of Nike Shoes Sold" at the bottom, click on the dropdown, and select an option below "Line." Click on one of the date series. And this is because your chart may overextend beyond the margins of your dashboard. Calculate metric tensor, inverse metric tensor, and Cristoffel symbols for Earth's surface, Is there and science or consensus or theory about whether a black or a white visor is better for cycling? In the Text direction box, click the text orientation that you want. The secondary axis requires a different chart from the primary axis chart. 3. July 20, 2022 3.6K Views 0 0 In a blank spreadsheet, we'll add the following three rows of data about Nike shoe sales for the process: Shoe sizes Number of shoes For example, if you calculate 10 / 100 = 0.1, and then format 0.1 as a percentage, the number will be correctly displayed as 10%. But it is a bit complicated to read enough. But were not recommending you to do away with Excel. Just because you have two y-axes doesnt mean data visualization best practices dont apply. 0. So I assume everything else is fine in your code which is not shown here.. You have to assign at least one series to AxisGroup xlSecondary. Click the Add Button under the "Legend Entries (Series)" and enter correct cells that have the data you want graphed. Gather your data into a spreadsheet in Excel. Once clicked, you'll see the chart appear below your data. Want more Excel tips? Generating second axis in a chart vba. This is the most advanced technique used in analytics to show two data sets in the same graph. Luckily, there's an easy fix. After the window opens, we must select the first clustered column chart. Labeling can help your audiences interpret charts in your data stories faster. The geographic regions will be uniformly spaced because they are text instead of values that can be measured. Then, click "Charts," navigate to the "Column" section, and select "Clustered Column" -- the first option, as shown below. By signing up, you agree to our Terms of Use and Privacy Policy. For example bar for the primary Y- axis and line for the secondary Y-axis. Frozen core Stability Calculations in G09? On the other hand, if bars are closely knitted together, they can obscure key insights or render your chart visually unimpressive. When you have mixed data types, it can be helpful to put one or more data series on a Y-Axis. Follow the same steps we highlighted in Example #1. It helps in analyzing multiple data sets in an easier way. You can supercharge your Excel by installing a particular add-in to access ready-made, visually appealing, and insightful charts. For the sake of completeness I transcribed the whole programme. Adding a secondary axis with Excel VBA. 2023 - EDUCBA. Select the line (or chart) associated with the second data series. Free and premium plans, Operations software. Thanks @bonCodigo, that works on Excel 2010. Make Row 1 your X-axis and Rows 2 and 3 your two Y-axes. Things to Keep in Mind while Creating a Chart with Secondary Y-Axis in Excel. Not the answer you're looking for? 2. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. To get started with ChartExpo, follow the easy steps below: This section will use the Multi-Axis Line Chart to show the practical application of adding a Secondary Y-axis in an Excel Chart. Have you ever wanted to create a single chart for two different (yet related) pieces of data? Select all the cells and labels you want to graph. Adjust your formatting to add a second axis in excel: We're not finished until your percentages are on their own Y axis on the right side of your chart. Under Axis Options, do one or both of the following: To change the interval between axis labels, under Interval between labels, click Specify interval unit, and then in the text box, type the number that you want. Look at how the columns for Number of Shoes Sold and Percent of Nike Shoes Sold cross each other. Your graph, which displays both the quantity of shoes sold and their percentage by shoe size, is prepared. Then, click into "Chart Design" on the menu bar on top of your Excel spreadsheet. Why can C not be lexed without resolving identifiers? On a chart, click the axis that has the tick marks and labels that you want to adjust, or do the following to select the axis from a list of chart elements: This displays the Chart Tools, adding the Design and Format tabs. Click on that dropdown, and click on your secondary axis name, which, in this case is "Percent of Nike Shoes Sold." But it declined in May and June before bouncing back to high levels in the following months until October. Right click on the date series and click Format Data Series. To remove the secondary y-axis from a chart is incredibly easy. 7. To add a second Y-axis, right- click on the line graph and select Format Data Series.. hbspt.cta._relativeUrls=true;hbspt.cta.load(53, '907656f8-87a9-4fe4-8dc1-05dca4c06a91', {"useNewLoader":"true","region":"na1"}); But there's a problem. In the top-left corner of your navigation bar, click Insert. Visualization designs with a secondary y-axis are among those limited charts (mentioned above). Click to learn how you can harness the power of a survey for market research. Note: Although the following Mac and Windows instructions used Microsoft Excel 2016 and 2013, respectively, users can create a secondary axis for their chart in most versions of Excel using variations of these steps. You need something called a secondary axis: it allows you to use the same X axis with two different sets of Y-axis data with two different scales. Consider, for example, the revenue of the company versus the employees. Thanks for contributing an answer to Stack Overflow! The chart can now be seen with two axes, as per the image below. Maybe you wanted to see the raw number of leads you're generating from each channel and what the conversion rate of the channel is. Also, well show you how to design a questionnaire. We know about basic charts, which implement a single axis. Next, we must select the chart and click on the Format Tab, as shown below. Right click the chart, and click Select Data from the right-clicking menu. Ordering can help your target audience (or readers) to interpret the chart. When you are finished, click the Expand Dialog Box button. On the Design tab, in the Data group, click Select Data. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a2\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-4.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-4.jpg","bigUrl":"\/images\/thumb\/a\/a2\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-4.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9b\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9b\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/76\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-4.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-4.jpg","bigUrl":"\/images\/thumb\/7\/76\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-4.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2c\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg","bigUrl":"\/images\/thumb\/2\/2c\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bb\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-4.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-4.jpg","bigUrl":"\/images\/thumb\/b\/bb\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-4.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f6\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/f6\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/13\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-4.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/13\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-4.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/52\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9-Version-2.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/52\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9-Version-2.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, Changing the Chart Type of the Secondary Axis, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/4c\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/da\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"