Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting lines between data points in a line chart
I have a simple line chart which graphs data over a 3-year timeframe.
Between each of the years, I would like there to be a gap in the line. In my previous version of Excel, I was able to do this by choosing "None" for the formatting of the line between the datapoints. In my current version of Excel (Excel 2002, XP operating system), if I choose "none" it simply charts a line between 2 non-contiguous months. For example, if I remove the line between December 2004 and January 2005, Excel 2002 will simply graph the line between December 2004 and February 2005. Anyone have a solution for this problem? -- ltanner |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |