|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 5th 07, 08:54 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
How do I make a line graph WITHOUT first line starting at zero?
|
| Ads |
|
#2
September 5th 07, 10:59 PM
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
September 5th 07, 11:36 PM
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
September 6th 07, 12:38 AM
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
September 6th 07, 02:50 PM
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
September 6th 07, 03:01 PM
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
September 6th 07, 03:26 PM
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
September 6th 07, 06:42 PM
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
September 7th 07, 12:26 AM
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
September 7th 07, 02:31 PM
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 >>> >>> >> ... >>> > >>> > >>> >>> >>> > >
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change line to bar in Line - Column graph | Yonke | Charts and Charting in Excel | 4 | January 16th 07 12:42 AM |
| How to change color of line and point markers on a line graph | SASPerson | Charts and Charting in Excel | 1 | November 15th 06 06:43 PM |
| How do you drop the line in a line graph? | LisaM | Charts and Charting in Excel | 1 | September 13th 06 08:56 PM |
| Make a line in a bar chart, and change color of any bars that exceed the line | MarkM | Excel Discussion (Misc queries) | 4 | July 5th 06 04:06 PM |
| can I make the vertical axis the category axis in Excel line graph | power1 | Charts and Charting in Excel | 1 | March 20th 06 08:45 PM |
Linear Mode
