Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a line chart in one spreadsheet that contains values that are linked (within the same spreadsheet) from two other spreadsheets.
What I can't figure out is why the first set of values (one year of data) displays as a normal line chart, but the second set of values (another year from the other spreadsheet) is all filled in. Here is what I'm trying to describe: Thanks for any help. -- Bill |
#2
![]() |
|||
|
|||
![]()
You might get some ideas from
http://www.peltiertech.com/Excel/Cha...AreaChart.html It is not clear from your post wether this behavior is desirable or undesirable. Jerry Bill H. wrote: I have a line chart in one spreadsheet that contains values that are linked (within the same spreadsheet) from two other spreadsheets. What I can't figure out is why the first set of values (one year of data) displays as a normal line chart, but the second set of values (another year from the other spreadsheet) is all filled in. |
#3
![]() |
|||
|
|||
![]()
Yeah, sorry about that.
It is undesirable. However, the good news is that I figured it out. Or more correctly stumbled upon it. One of the referenced cells has a few years' worth of dates, and when I updated to reflect 2005, I just "assumed" that the cells containing short dates, like 1/5, meant the current year. Nope, they were lefovers from 2004 and didn't indicate the year. When I redid that stretch to make them all 2005 dates, the graph straightened out just fine. Sheesh! "Jerry W. Lewis" wrote in message ... You might get some ideas from http://www.peltiertech.com/Excel/Cha...AreaChart.html It is not clear from your post wether this behavior is desirable or undesirable. Jerry Bill H. wrote: I have a line chart in one spreadsheet that contains values that are linked (within the same spreadsheet) from two other spreadsheets. What I can't figure out is why the first set of values (one year of data) displays as a normal line chart, but the second set of values (another year from the other spreadsheet) is all filled in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Creating a chart with values from two columns | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
HOW TO: Plot a Team Name on a chart based on two values | Charts and Charting in Excel |