PC Review


Reply
Thread Tools Rate Thread

chart trouble

 
 
=?Utf-8?B?Y2hpbGVncm93cg==?=
Guest
Posts: n/a
 
      14th Sep 2005
I'm making a simple chart, with 2 series with 2 data points in each series,
but only the first set of data points are graphed
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      15th Sep 2005
Are you making an XY chart? Excel might be using the first series as the
X values for the second series. Try this kind of data arrangement:

Srs-a Srs-b
X1 Y1a Y1b
X2 Y2a Y2b

Srs-a and Srs-b are the series names (legend entries) for the two
series, and you are explicitly providing X values for both series in the
first column. Select this 3x3 range, run the chart wizard, and in step
2, make sure the series are in columns.

[BTW, shouldn't that be chiligrowr?]

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


chilegrowr wrote:

> I'm making a simple chart, with 2 series with 2 data points in each series,
> but only the first set of data points are graphed

 
Reply With Quote
 
R.VENKATARAMAN
Guest
Posts: n/a
 
      15th Sep 2005
did you choose <series> in the source data window
and then add one by one the series
easy to do is click on an empty cell and hit F11.
in the chart sheet right click and click <sourcedata>
and choose <seris>

there may be other ways of doing this.

--
remove $$$ from email addresss to send email
===========
"chilegrowr" <(E-Mail Removed)> wrote in message
news:7B0C88BA-B03B-448F-9564-(E-Mail Removed)...
> I'm making a simple chart, with 2 series with 2 data points in each

series,
> but only the first set of data points are graphed



 
Reply With Quote
 
=?Utf-8?B?Y2hpbGVncm93cg==?=
Guest
Posts: n/a
 
      15th Sep 2005
thanks, i'll give it a go in the morning. btw: "chili" is that meat and
chiles and tomatoes stuff in a can at the supermarket!

"Jon Peltier" wrote:

> Are you making an XY chart? Excel might be using the first series as the
> X values for the second series. Try this kind of data arrangement:
>
> Srs-a Srs-b
> X1 Y1a Y1b
> X2 Y2a Y2b
>
> Srs-a and Srs-b are the series names (legend entries) for the two
> series, and you are explicitly providing X values for both series in the
> first column. Select this 3x3 range, run the chart wizard, and in step
> 2, make sure the series are in columns.
>
> [BTW, shouldn't that be chiligrowr?]
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> chilegrowr wrote:
>
> > I'm making a simple chart, with 2 series with 2 data points in each series,
> > but only the first set of data points are graphed

>

 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      15th Sep 2005
I thought chilis were the peppers, and Chile was the country.

- Jon

chilegrowr wrote:

> thanks, i'll give it a go in the morning. btw: "chili" is that meat and
> chiles and tomatoes stuff in a can at the supermarket!
>
> "Jon Peltier" wrote:
>
>
>>Are you making an XY chart? Excel might be using the first series as the
>>X values for the second series. Try this kind of data arrangement:
>>
>> Srs-a Srs-b
>>X1 Y1a Y1b
>>X2 Y2a Y2b
>>
>>Srs-a and Srs-b are the series names (legend entries) for the two
>>series, and you are explicitly providing X values for both series in the
>>first column. Select this 3x3 range, run the chart wizard, and in step
>>2, make sure the series are in columns.
>>
>>[BTW, shouldn't that be chiligrowr?]
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>
>>chilegrowr wrote:
>>
>>
>>>I'm making a simple chart, with 2 series with 2 data points in each series,
>>>but only the first set of data points are graphed

>>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
having trouble with a chart range mandjdubois@hotmail.com Microsoft Excel Programming 1 11th Feb 2008 09:13 PM
Pie Chart Trouble =?Utf-8?B?V29sZlBhY2s=?= Microsoft Access Reports 0 4th Apr 2006 04:51 PM
Line Chart Trouble =?Utf-8?B?VGhpcyBHdXk=?= Microsoft Access Reports 1 29th Nov 2005 03:47 AM
how do i chart H:mm?? im having trouble kerry78 Microsoft Excel Charting 1 26th Aug 2004 03:50 PM
HELP, chart trouble raptyrred Microsoft Excel Charting 1 17th Jan 2004 01:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:43 PM.