Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird issue with very simple line chart - urgent
Hi everyone - I have a very simple data that I want to chart on a line. Two
rows of data, 10 columns (years from now until 2017), simply showing the values of two items. I want a line graph to show how these values compare over time. But when I chart them, one of the series is fine, but the other seems to just "add" its value to the first. So, for example, in 2010, series A value is 50 and series B value is 70. But on the graph, series B is shown as 120 on the Y axis. When I chart it on the secondary axis, it is fine. What am I doing wrong!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird issue with very simple line chart - urgent
Probably you selected Stacked line from the Chart sub-type list. Change it to
simple Line! Regards, Stefi €˛Totteridge Ram€¯ ezt Ć*rta: Hi everyone - I have a very simple data that I want to chart on a line. Two rows of data, 10 columns (years from now until 2017), simply showing the values of two items. I want a line graph to show how these values compare over time. But when I chart them, one of the series is fine, but the other seems to just "add" its value to the first. So, for example, in 2010, series A value is 50 and series B value is 70. But on the graph, series B is shown as 120 on the Y axis. When I chart it on the secondary axis, it is fine. What am I doing wrong!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird issue with very simple line chart - urgent
Duh!!
Thanks a lot Stefi, this has worked fine. I was going round the twist!! "Stefi" wrote: Probably you selected Stacked line from the Chart sub-type list. Change it to simple Line! Regards, Stefi €˛Totteridge Ram€¯ ezt Ć*rta: Hi everyone - I have a very simple data that I want to chart on a line. Two rows of data, 10 columns (years from now until 2017), simply showing the values of two items. I want a line graph to show how these values compare over time. But when I chart them, one of the series is fine, but the other seems to just "add" its value to the first. So, for example, in 2010, series A value is 50 and series B value is 70. But on the graph, series B is shown as 120 on the Y axis. When I chart it on the secondary axis, it is fine. What am I doing wrong!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird issue with very simple line chart - urgent
You are welcome! Thanks for the feedback!
Stefi €˛Totteridge Ram€¯ ezt Ć*rta: Duh!! Thanks a lot Stefi, this has worked fine. I was going round the twist!! "Stefi" wrote: Probably you selected Stacked line from the Chart sub-type list. Change it to simple Line! Regards, Stefi €˛Totteridge Ram€¯ ezt Ć*rta: Hi everyone - I have a very simple data that I want to chart on a line. Two rows of data, 10 columns (years from now until 2017), simply showing the values of two items. I want a line graph to show how these values compare over time. But when I chart them, one of the series is fine, but the other seems to just "add" its value to the first. So, for example, in 2010, series A value is 50 and series B value is 70. But on the graph, series B is shown as 120 on the Y axis. When I chart it on the secondary axis, it is fine. What am I doing wrong!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't create a simple Line Chart | New Users to Excel | |||
simple bar and line chart | Charts and Charting in Excel | |||
Access line chart issue | Charts and Charting in Excel | |||
Urgent help regarding line chart thru Excel-VBA | Charts and Charting in Excel | |||
This is Weird - Dead Simple Issue with Sum Function | Excel Worksheet Functions |