| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I make a line graph WITHOUT first line starting at zero?
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero?
Do you want an XY chart instead?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
I want a line chart that doesn't have the line starting at zero. This is an
XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
Define "Starting at zero". Is the first X value at zero? The first Y value?
In fact, what does your data look like? Did you know an XY chart and a line chart can both be formatted with lines connecting the data points? The XY chart provides more flexibility regarding the X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... I want a line chart that doesn't have the line starting at zero. This is an XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
Can you tell me how to connect the data points! That's what I want.
"Jon Peltier" wrote: Define "Starting at zero". Is the first X value at zero? The first Y value? In fact, what does your data look like? Did you know an XY chart and a line chart can both be formatted with lines connecting the data points? The XY chart provides more flexibility regarding the X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... I want a line chart that doesn't have the line starting at zero. This is an XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
For the chart as a whole, look at the sub-types against XY chart under Chart
Type. For an individual data series, Format Data Series. -- David Biddulph "NorthStar" wrote in message ... Can you tell me how to connect the data points! That's what I want. "Jon Peltier" wrote: Define "Starting at zero". Is the first X value at zero? The first Y value? In fact, what does your data look like? Did you know an XY chart and a line chart can both be formatted with lines connecting the data points? The XY chart provides more flexibility regarding the X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... I want a line chart that doesn't have the line starting at zero. This is an XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
Or double click on the series, and on the Patterns tab, format the line.
If for whatever reason you still are not getting a line, it's because of blank cells between values, where the blanks are not being plotted. Go to Tools menu Options Chart, and choose Interpolate in the top section. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... For the chart as a whole, look at the sub-types against XY chart under Chart Type. For an individual data series, Format Data Series. -- David Biddulph "NorthStar" wrote in message ... Can you tell me how to connect the data points! That's what I want. "Jon Peltier" wrote: Define "Starting at zero". Is the first X value at zero? The first Y value? In fact, what does your data look like? Did you know an XY chart and a line chart can both be formatted with lines connecting the data points? The XY chart provides more flexibility regarding the X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... I want a line chart that doesn't have the line starting at zero. This is an XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
Is the only way of not having the lines start on zero, is by clicking on that
line and choosing "no Line". Or is there another way in someother option? "Jon Peltier" wrote: Or double click on the series, and on the Patterns tab, format the line. If for whatever reason you still are not getting a line, it's because of blank cells between values, where the blanks are not being plotted. Go to Tools menu Options Chart, and choose Interpolate in the top section. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... For the chart as a whole, look at the sub-types against XY chart under Chart Type. For an individual data series, Format Data Series. -- David Biddulph "NorthStar" wrote in message ... Can you tell me how to connect the data points! That's what I want. "Jon Peltier" wrote: Define "Starting at zero". Is the first X value at zero? The first Y value? In fact, what does your data look like? Did you know an XY chart and a line chart can both be formatted with lines connecting the data points? The XY chart provides more flexibility regarding the X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... I want a line chart that doesn't have the line starting at zero. This is an XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
In an earlier message on this thread, Jon Peltier asked you what you meant
by lines starting on zero. X = 0 ? Y = 0 ? He asked what your data looked like. As far as I can see, you didn't bother replying. -- David Biddulph "NorthStar" wrote in message ... Is the only way of not having the lines start on zero, is by clicking on that line and choosing "no Line". Or is there another way in someother option? "Jon Peltier" wrote: Or double click on the series, and on the Patterns tab, format the line. If for whatever reason you still are not getting a line, it's because of blank cells between values, where the blanks are not being plotted. Go to Tools menu Options Chart, and choose Interpolate in the top section. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... For the chart as a whole, look at the sub-types against XY chart under Chart Type. For an individual data series, Format Data Series. -- David Biddulph "NorthStar" wrote in message ... Can you tell me how to connect the data points! That's what I want. "Jon Peltier" wrote: Define "Starting at zero". Is the first X value at zero? The first Y value? In fact, what does your data look like? Did you know an XY chart and a line chart can both be formatted with lines connecting the data points? The XY chart provides more flexibility regarding the X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... I want a line chart that doesn't have the line starting at zero. This is an XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
|
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I make a line graph WITHOUT first line starting at zero
Thanks, David. That was going to be my next post.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... In an earlier message on this thread, Jon Peltier asked you what you meant by lines starting on zero. X = 0 ? Y = 0 ? He asked what your data looked like. As far as I can see, you didn't bother replying. -- David Biddulph "NorthStar" wrote in message ... Is the only way of not having the lines start on zero, is by clicking on that line and choosing "no Line". Or is there another way in someother option? "Jon Peltier" wrote: Or double click on the series, and on the Patterns tab, format the line. If for whatever reason you still are not getting a line, it's because of blank cells between values, where the blanks are not being plotted. Go to Tools menu Options Chart, and choose Interpolate in the top section. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... For the chart as a whole, look at the sub-types against XY chart under Chart Type. For an individual data series, Format Data Series. -- David Biddulph "NorthStar" wrote in message ... Can you tell me how to connect the data points! That's what I want. "Jon Peltier" wrote: Define "Starting at zero". Is the first X value at zero? The first Y value? In fact, what does your data look like? Did you know an XY chart and a line chart can both be formatted with lines connecting the data points? The XY chart provides more flexibility regarding the X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... I want a line chart that doesn't have the line starting at zero. This is an XY chart. "Jon Peltier" wrote: Do you want an XY chart instead? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "NorthStar" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change line to bar in Line - Column graph | Charts and Charting in Excel | |||
| How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
| How do you drop the line in a line graph? | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Linear Mode
