Solved

Help with adding another set of values to existing chart

Posted on 2013-01-08
3
199 Views
Last Modified: 2013-01-08
Dear Sir/Madam,
I am requesting assistance with a chart of data (please see attached spreadsheet).  In the attached, I have created a chart for the years of 1997, 2002, 2007 and 2011 with the corresponding values for the millions of tons of freight.

Next, I need to incorporate the values of the percentage change for each of the four years, with 1997 being the base year.  I would like to axis on the right side of the chart to be values of 0.5, 1.0, 1.5 and 2.0.  Thus, all 3 values (Import, Export, Domestic) would start at 1.0 for 1997, and then three separate lines (of different colors) representing the increase/decrease from 1997 (the values are in lines 10-12).  For example, for "Imports", a dot would appear on the year 1997 for the axis value of 1.0.  Then the line would go up to 1.19 for year 2002, up to 1.36 for 2007, etc.  Same for 'Exports' and 'Domestic'.  

Please advise if I am not being clear.  I always have trouble adding another axis to an existing chart.  So, please, in addition to performing the request, can you please advise how you did it so I can learn as well since I have always wondered how.

Thank you as always.  Your team is always of great help.
-James
ExpertsExchange-Question21.xlsx
0
Comment
Question by:James0903
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
terencino earned 500 total points
ID: 38757510
And as always James your questions have awesome clarity. I think you are looking for a combo chart like attached.
Let me know if further assist required
...Terry
ExpertsExchange-Question21-1.xlsx
0
 
LVL 16

Expert Comment

by:terencino
ID: 38757523
To create the combo chart, copy the whole range of the Percentage difference data, select the chart and hit paste. Then, right click on the chart and hit Change Chart Type, then select Combo down at the bottom of the list. Change the first three back to Stacked Column, and check the Secondary Axis box on the right for the last three. These instructions are for Excel 2013, but earlier versions are similar.
...Terry
0
 

Author Closing Comment

by:James0903
ID: 38757617
Terry, great, thank you as always for both a job well done and detailed instructions.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
question about excel functionality 3 31
Formatting code for Excel Forms 17 48
Excel formula with two ifs 9 27
Date Formatting on Userform Print 5 26
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question