software

Please use the white space to give a fuller message. The term 'expand the
field' is unclear.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Theresaquot; gt; wrote in message
...
gt;
I am trying to add more fields to my x axis than the 7 allowed. My chart is
short fields needed, it is almost as if I need a secondary axis but I am not
using a pivot chart. All the information appears on the chart blank because I
am not able to load the information from excell. I would like to know how to
create a fornula of sort to load all of the information that is needed. It is
not a continous field or I could flow with ( but alot has to be skipped
thus (,) and( ) making my factor of the 7 dropping quickly.

quot;Bernard Liengmequot; wrote:

gt; Please use the white space to give a fuller message. The term 'expand the
gt; field' is unclear.
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Theresaquot; gt; wrote in message
gt; ...
gt; gt;
gt;
gt;
gt;

Please show us a sample of the data. The term 'field' is still confusing.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Theresaquot; gt; wrote in message
...
gt;I am trying to add more fields to my x axis than the 7 allowed. My chart is
gt; short fields needed, it is almost as if I need a secondary axis but I am
gt; not
gt; using a pivot chart. All the information appears on the chart blank
gt; because I
gt; am not able to load the information from excell. I would like to know how
gt; to
gt; create a fornula of sort to load all of the information that is needed. It
gt; is
gt; not a continous field or I could flow with ( but alot has to be skipped
gt; thus (,) and( ) making my factor of the 7 dropping quickly.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Please use the white space to give a fuller message. The term 'expand the
gt;gt; field' is unclear.
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Theresaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
I'm confused as well.

If you go to the Chart menu and select Source Data, do you have a meaningful
range displayed in the Data Range tab's entry box? How about in the Series
tab, when you select a series, do the entry boxes show valid ranges? Can you
extend these ranges (i.e., select a larger range)?

It sounds like you might have added data by using CTRL to select dispersed
cells. You should really try to get all your X values into a column, and the
corresponding Y values in the next column to the right. It's not mandatory,
but it will make your life much easier.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Theresaquot; gt; wrote in message
...
gt;I am trying to add more fields to my x axis than the 7 allowed. My chart is
gt; short fields needed, it is almost as if I need a secondary axis but I am
gt; not
gt; using a pivot chart. All the information appears on the chart blank
gt; because I
gt; am not able to load the information from excell. I would like to know how
gt; to
gt; create a fornula of sort to load all of the information that is needed. It
gt; is
gt; not a continous field or I could flow with ( but alot has to be skipped
gt; thus (,) and( ) making my factor of the 7 dropping quickly.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Please use the white space to give a fuller message. The term 'expand the
gt;gt; field' is unclear.
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Theresaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
The problem that I have run into is that I have more information in my row
that needs to be put into my axis to than is allowed by excell for my chart
and I do not know how to expand my information. The information is showing on
the chart but is collecting in one lump row due to the limited space. You
asked that I send you a copy of the information that I was working with, I
have emailed this to you as I feel better in doing that, since this is a
large character. I appreciate any help that you can give me as I have total
racked my brain as well as others.quot;Bernard Liengmequot; wrote:

gt; Please show us a sample of the data. The term 'field' is still confusing.
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Theresaquot; gt; wrote in message
gt; ...
gt; gt;I am trying to add more fields to my x axis than the 7 allowed. My chart is
gt; gt; short fields needed, it is almost as if I need a secondary axis but I am
gt; gt; not
gt; gt; using a pivot chart. All the information appears on the chart blank
gt; gt; because I
gt; gt; am not able to load the information from excell. I would like to know how
gt; gt; to
gt; gt; create a fornula of sort to load all of the information that is needed. It
gt; gt; is
gt; gt; not a continous field or I could flow with ( but alot has to be skipped
gt; gt; thus (,) and( ) making my factor of the 7 dropping quickly.
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; Please use the white space to give a fuller message. The term 'expand the
gt; gt;gt; field' is unclear.
gt; gt;gt; best wishes
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt; quot;Theresaquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;



quot;Jon Peltierquot; wrote:

gt; I'm confused as well.
gt;
gt; If you go to the Chart menu and select Source Data, do you have a meaningful
gt; range displayed in the Data Range tab's entry box? How about in the Series
gt; tab, when you select a series, do the entry boxes show valid ranges? Can you
gt; extend these ranges (i.e., select a larger range)?
gt;
gt; It sounds like you might have added data by using CTRL to select dispersed
gt; cells. You should really try to get all your X values into a column, and the
gt; corresponding Y values in the next column to the right. It's not mandatory,
gt; but it will make your life much easier.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;Theresaquot; gt; wrote in message
gt; ...
gt; gt;I am trying to add more fields to my x axis than the 7 allowed. My chart is
gt; gt; short fields needed, it is almost as if I need a secondary axis but I am
gt; gt; not
gt; gt; using a pivot chart. All the information appears on the chart blank
gt; gt; because I
gt; gt; am not able to load the information from excell. I would like to know how
gt; gt; to
gt; gt; create a fornula of sort to load all of the information that is needed. It
gt; gt; is
gt; gt; not a continous field or I could flow with ( but alot has to be skipped
gt; gt; thus (,) and( ) making my factor of the 7 dropping quickly.
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; Please use the white space to give a fuller message. The term 'expand the
gt; gt;gt; field' is unclear.
gt; gt;gt; best wishes
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt; quot;Theresaquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;It looks as if my last reply did not show, this is where I stand at this time. The formula that excel is allowing for axis X is as follows:
= ('C11:27, E37, C41, C49, C69, C73, C77, C76, C77, C91, C96, C112:C138)
I still need the rows C143, C155:161, C166, C171:179 to be added to the
chart for the information to be seperated on my graph correctly. The
information is appearing n the graph but not flowing as it should. It is
currently all dumpin on the Y axis on one line since the information has no
where to flow on the X axis.
How can I add the additional information? I am doing this thru the series
application and I do have an X, Y and Z axis. With X being my larger one.
Sorry if I confused everyone. It has been a while since using the programs.
gt; gt;gt;
gt;
gt;
gt;

gt; It looks as if my last reply did not show, this is where I stand at this
gt; time. The formula that excel is allowing for axis X is as follows:
gt; = ('C11:27, E37, C41, C49, C69, C73, C77, C76, C77, C91, C96, C112:C138)
gt; I still need the rows C143, C155:161, C166, C171:179 to be added to the
gt; chart for the information to be seperated on my graph correctly. The
gt; information is appearing n the graph but not flowing as it should. It is
gt; currently all dumpin on the Y axis on one line since the information has
gt; no
gt; where to flow on the X axis.
gt; How can I add the additional information? I am doing this thru the series
gt; application and I do have an X, Y and Z axis. With X being my larger one.
gt; Sorry if I confused everyone. It has been a while since using the
gt; programs.

Rather than having a ton of discontiguous cells as your data source range,
you should try to eliminate all of the not-plotting cells in between. If you
cannot do this on your original data sheet, make a data sheet for the chart,
which links to the data you need, without all of the blanks. This will
greatly simplify your future work with this and similar charts.

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