Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple line charts - merged
Hi there,
I'm pretty new with plotting charts, so hoping someone can point me in the right direction. I'm trying to make a graph with the following: Along the X-Axis will be the years 2000-2006 Along the Y-Axis will be numbers ranging from 0-28 I would also like another Y-Axis (on the right side of the chart) to have numbers from 900-1800 I'm trying to make a graph that will show that the number of members has declined over the years, while the number of people in the community has been increasing. Here are my columns Year - Members - Population 2000 - 22 - 961 2001 - 27 - 1273 2002 - 16 - 1548 2003 - 5 - 1552 2004 - 6 - 1418 2005 - 3 - 1776 2006 - 2 - 1368 Thanks for your help!! Matt |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple line charts - merged
Clear the cell that says Year in the top left-hand corner. Select the whole
range (including the column headers). Insert/ Chart/ XY (& choose an appropriate sub-type, with lines if you want)/ Data in columns. Continue through, selecting your preferred options. You'll end up with a chart with one Y-axis, but if you select your Population series, you can use Format Series, axis tab, select secondary axis. Fine tune thereafter -- David Biddulph "mpenkala" wrote in message ... Hi there, I'm pretty new with plotting charts, so hoping someone can point me in the right direction. I'm trying to make a graph with the following: Along the X-Axis will be the years 2000-2006 Along the Y-Axis will be numbers ranging from 0-28 I would also like another Y-Axis (on the right side of the chart) to have numbers from 900-1800 I'm trying to make a graph that will show that the number of members has declined over the years, while the number of people in the community has been increasing. Here are my columns Year - Members - Population 2000 - 22 - 961 2001 - 27 - 1273 2002 - 16 - 1548 2003 - 5 - 1552 2004 - 6 - 1418 2005 - 3 - 1776 2006 - 2 - 1368 Thanks for your help!! Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel; shows a line of # instead of my text in a merged cell. | Excel Discussion (Misc queries) | |||
Multi line merged cell - adapting to different size input - possible? | Excel Discussion (Misc queries) | |||
Charts Line Types for Multiple Data Series not Printing Properly | Charts and Charting in Excel | |||
Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) | |||
Can I set a filter for a merged column across multiple rows and o. | Excel Worksheet Functions |