I wish to limit my chart to only the data I entered into the spreadsheet.
How can I suppress the use of the row numbers as the x-axis on a line chart?
I want the leftmost selected column to be my horizontal axis, relative to
which every other column is displayed. I also need to control the scale of
the vertical axis, but quot;helpquot; doesn't help with that either.
How can I do this?
Richard
If the first column contains text information, select any cell in the range
you want charted, then click the Chart Wizard button. XL should use the
first column as the x-axis values.
If it doesn't you have two choices. Either delete the header of the first
column, then follow the steps in the previous paragraph or in the 2nd step of
the chart wizard click the Series tab and then set the first column as the
Category (X) values.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approachquot;Richard Erlacherquot; wrote:
gt; I wish to limit my chart to only the data I entered into the spreadsheet.
gt; How can I suppress the use of the row numbers as the x-axis on a line chart?
gt;
gt; I want the leftmost selected column to be my horizontal axis, relative to
gt; which every other column is displayed. I also need to control the scale of
gt; the vertical axis, but quot;helpquot; doesn't help with that either.
gt;
gt; How can I do this?
gt;
gt; Richard
gt;
gt;
gt;
Nope, these are all numbers. However, it's the row-numbers that are
currently appearing on the x-axis of my chart, and it's the first columnt in
my data set that I want used. I had the impression that if I select just
the columns I want presented in my chart, XL will use the leftmost as the
quot;defaultquot; x-axis.
The problem isn't that it's not using data I do want used, but, rather,
quite the opposite. Those line-numbers are meaningless on my chart and I
want the vaules in my first column used instead.
Regards,
Richard
quot;Tushar Mehtaquot; gt; wrote in message
...
gt; If the first column contains text information, select any cell in the
gt; range
gt; you want charted, then click the Chart Wizard button. XL should use the
gt; first column as the x-axis values.
gt;
gt; If it doesn't you have two choices. Either delete the header of the first
gt; column, then follow the steps in the previous paragraph or in the 2nd step
gt; of
gt; the chart wizard click the Series tab and then set the first column as the
gt; Category (X) values.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Custom business solutions leveraging a multi-disciplinary approach
gt;
gt;
gt; quot;Richard Erlacherquot; wrote:
gt;
gt;gt; I wish to limit my chart to only the data I entered into the spreadsheet.
gt;gt; How can I suppress the use of the row numbers as the x-axis on a line
gt;gt; chart?
gt;gt;
gt;gt; I want the leftmost selected column to be my horizontal axis, relative to
gt;gt; which every other column is displayed. I also need to control the scale
gt;gt; of
gt;gt; the vertical axis, but quot;helpquot; doesn't help with that either.
gt;gt;
gt;gt; How can I do this?
gt;gt;
gt;gt; Richard
gt;gt;
gt;gt;
gt;gt;
Do you want a line chart, or an XY chart? Is there any numerical
significance to the numbers? A line chart will plot them as labels in the
order they appear in the worksheet, uniformly spaced across the bottom of
the chart, without regard to the value of the numbers. An XY chart plots X
as a value vs. Y as a value. An XY chart will also automatically use the
first column for X values, while a line chart only does sometimes.
You also asked about scaling the Y axis. Double click on it, click on the
Scale tab, then enter values you prefer to the automatic values Excel
computes. Don't check the boxes in front of the numbers after you change
them (seems silly, but lots of people do this and wonder why their entries
are ignored).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______
quot;Richard Erlacherquot; gt; wrote in message
...
gt; Nope, these are all numbers. However, it's the row-numbers that are
gt; currently appearing on the x-axis of my chart, and it's the first columnt
gt; in my data set that I want used. I had the impression that if I select
gt; just the columns I want presented in my chart, XL will use the leftmost as
gt; the quot;defaultquot; x-axis.
gt;
gt; The problem isn't that it's not using data I do want used, but, rather,
gt; quite the opposite. Those line-numbers are meaningless on my chart and I
gt; want the vaules in my first column used instead.
gt;
gt; Regards,
gt;
gt; Richard
gt;
gt; quot;Tushar Mehtaquot; gt; wrote in message
gt; ...
gt;gt; If the first column contains text information, select any cell in the
gt;gt; range
gt;gt; you want charted, then click the Chart Wizard button. XL should use the
gt;gt; first column as the x-axis values.
gt;gt;
gt;gt; If it doesn't you have two choices. Either delete the header of the
gt;gt; first
gt;gt; column, then follow the steps in the previous paragraph or in the 2nd
gt;gt; step of
gt;gt; the chart wizard click the Series tab and then set the first column as
gt;gt; the
gt;gt; Category (X) values.
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Tushar Mehta
gt;gt; www.tushar-mehta.com
gt;gt; Custom business solutions leveraging a multi-disciplinary approach
gt;gt;
gt;gt;
gt;gt; quot;Richard Erlacherquot; wrote:
gt;gt;
gt;gt;gt; I wish to limit my chart to only the data I entered into the
gt;gt;gt; spreadsheet.
gt;gt;gt; How can I suppress the use of the row numbers as the x-axis on a line
gt;gt;gt; chart?
gt;gt;gt;
gt;gt;gt; I want the leftmost selected column to be my horizontal axis, relative
gt;gt;gt; to
gt;gt;gt; which every other column is displayed. I also need to control the scale
gt;gt;gt; of
gt;gt;gt; the vertical axis, but quot;helpquot; doesn't help with that either.
gt;gt;gt;
gt;gt;gt; How can I do this?
gt;gt;gt;
gt;gt;gt; Richard
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;
gt;
I also took the time to give you two options on how to handle the case where
the first column contains numbers. You may want to go back and look at my
post again.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approachquot;Richard Erlacherquot; wrote:
gt; Nope, these are all numbers. However, it's the row-numbers that are
gt; currently appearing on the x-axis of my chart, and it's the first columnt in
gt; my data set that I want used. I had the impression that if I select just
gt; the columns I want presented in my chart, XL will use the leftmost as the
gt; quot;defaultquot; x-axis.
gt;
gt; The problem isn't that it's not using data I do want used, but, rather,
gt; quite the opposite. Those line-numbers are meaningless on my chart and I
gt; want the vaules in my first column used instead.
gt;
gt; Regards,
gt;
gt; Richard
gt;
gt; quot;Tushar Mehtaquot; gt; wrote in message
gt; ...
gt; gt; If the first column contains text information, select any cell in the
gt; gt; range
gt; gt; you want charted, then click the Chart Wizard button. XL should use the
gt; gt; first column as the x-axis values.
gt; gt;
gt; gt; If it doesn't you have two choices. Either delete the header of the first
gt; gt; column, then follow the steps in the previous paragraph or in the 2nd step
gt; gt; of
gt; gt; the chart wizard click the Series tab and then set the first column as the
gt; gt; Category (X) values.
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Tushar Mehta
gt; gt; www.tushar-mehta.com
gt; gt; Custom business solutions leveraging a multi-disciplinary approach
gt; gt;
gt; gt;
gt; gt; quot;Richard Erlacherquot; wrote:
gt; gt;
gt; gt;gt; I wish to limit my chart to only the data I entered into the spreadsheet.
gt; gt;gt; How can I suppress the use of the row numbers as the x-axis on a line
gt; gt;gt; chart?
gt; gt;gt;
gt; gt;gt; I want the leftmost selected column to be my horizontal axis, relative to
gt; gt;gt; which every other column is displayed. I also need to control the scale
gt; gt;gt; of
gt; gt;gt; the vertical axis, but quot;helpquot; doesn't help with that either.
gt; gt;gt;
gt; gt;gt; How can I do this?
gt; gt;gt;
gt; gt;gt; Richard
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;
Jon,
This is supposed to be a line chart. I have several lines I want to have
appear, the leftmost of which is intended to be the X-axis. Unfortunately,
instead of this, XL is using the row numbers on the left margin of the page,
which is not helpful. It works as well, I guess as an XY chart. That way I
get what I want to show.
Thanks for the help.
regards,
Richard
quot;Jon Peltierquot; gt; wrote in message
...
gt; Do you want a line chart, or an XY chart? Is there any numerical
gt; significance to the numbers? A line chart will plot them as labels in the
gt; order they appear in the worksheet, uniformly spaced across the bottom of
gt; the chart, without regard to the value of the numbers. An XY chart plots X
gt; as a value vs. Y as a value. An XY chart will also automatically use the
gt; first column for X values, while a line chart only does sometimes.
gt;
gt; You also asked about scaling the Y axis. Double click on it, click on the
gt; Scale tab, then enter values you prefer to the automatic values Excel
gt; computes. Don't check the boxes in front of the numbers after you change
gt; them (seems silly, but lots of people do this and wonder why their entries
gt; are ignored).
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Richard Erlacherquot; gt; wrote in message
gt; ...
gt;gt; Nope, these are all numbers. However, it's the row-numbers that are
gt;gt; currently appearing on the x-axis of my chart, and it's the first columnt
gt;gt; in my data set that I want used. I had the impression that if I select
gt;gt; just the columns I want presented in my chart, XL will use the leftmost
gt;gt; as the quot;defaultquot; x-axis.
gt;gt;
gt;gt; The problem isn't that it's not using data I do want used, but, rather,
gt;gt; quite the opposite. Those line-numbers are meaningless on my chart and I
gt;gt; want the vaules in my first column used instead.
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Richard
gt;gt;
gt;gt; quot;Tushar Mehtaquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; If the first column contains text information, select any cell in the
gt;gt;gt; range
gt;gt;gt; you want charted, then click the Chart Wizard button. XL should use
gt;gt;gt; the
gt;gt;gt; first column as the x-axis values.
gt;gt;gt;
gt;gt;gt; If it doesn't you have two choices. Either delete the header of the
gt;gt;gt; first
gt;gt;gt; column, then follow the steps in the previous paragraph or in the 2nd
gt;gt;gt; step of
gt;gt;gt; the chart wizard click the Series tab and then set the first column as
gt;gt;gt; the
gt;gt;gt; Category (X) values.
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Regards,
gt;gt;gt;
gt;gt;gt; Tushar Mehta
gt;gt;gt; www.tushar-mehta.com
gt;gt;gt; Custom business solutions leveraging a multi-disciplinary approach
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;Richard Erlacherquot; wrote:
gt;gt;gt;
gt;gt;gt;gt; I wish to limit my chart to only the data I entered into the
gt;gt;gt;gt; spreadsheet.
gt;gt;gt;gt; How can I suppress the use of the row numbers as the x-axis on a line
gt;gt;gt;gt; chart?
gt;gt;gt;gt;
gt;gt;gt;gt; I want the leftmost selected column to be my horizontal axis, relative
gt;gt;gt;gt; to
gt;gt;gt;gt; which every other column is displayed. I also need to control the
gt;gt;gt;gt; scale of
gt;gt;gt;gt; the vertical axis, but quot;helpquot; doesn't help with that either.
gt;gt;gt;gt;
gt;gt;gt;gt; How can I do this?
gt;gt;gt;gt;
gt;gt;gt;gt; Richard
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
While I appreciate what you told me, Tushar, I didn't understand it well
enough to use it. The data is all numeric. I've got a few more of these to
do, so I'll give your method a try as well just so I know what it is and how
it works.
Richard
quot;Tushar Mehtaquot; gt; wrote in message
...
gt;I also took the time to give you two options on how to handle the case
gt;where
gt; the first column contains numbers. You may want to go back and look at my
gt; post again.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Custom business solutions leveraging a multi-disciplinary approach
gt;
gt;
gt; quot;Richard Erlacherquot; wrote:
gt;
gt;gt; Nope, these are all numbers. However, it's the row-numbers that are
gt;gt; currently appearing on the x-axis of my chart, and it's the first columnt
gt;gt; in
gt;gt; my data set that I want used. I had the impression that if I select just
gt;gt; the columns I want presented in my chart, XL will use the leftmost as the
gt;gt; quot;defaultquot; x-axis.
gt;gt;
gt;gt; The problem isn't that it's not using data I do want used, but, rather,
gt;gt; quite the opposite. Those line-numbers are meaningless on my chart and I
gt;gt; want the vaules in my first column used instead.
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Richard
gt;gt;
gt;gt; quot;Tushar Mehtaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; If the first column contains text information, select any cell in the
gt;gt; gt; range
gt;gt; gt; you want charted, then click the Chart Wizard button. XL should use
gt;gt; gt; the
gt;gt; gt; first column as the x-axis values.
gt;gt; gt;
gt;gt; gt; If it doesn't you have two choices. Either delete the header of the
gt;gt; gt; first
gt;gt; gt; column, then follow the steps in the previous paragraph or in the 2nd
gt;gt; gt; step
gt;gt; gt; of
gt;gt; gt; the chart wizard click the Series tab and then set the first column as
gt;gt; gt; the
gt;gt; gt; Category (X) values.
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Regards,
gt;gt; gt;
gt;gt; gt; Tushar Mehta
gt;gt; gt; www.tushar-mehta.com
gt;gt; gt; Custom business solutions leveraging a multi-disciplinary approach
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Richard Erlacherquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; I wish to limit my chart to only the data I entered into the
gt;gt; gt;gt; spreadsheet.
gt;gt; gt;gt; How can I suppress the use of the row numbers as the x-axis on a line
gt;gt; gt;gt; chart?
gt;gt; gt;gt;
gt;gt; gt;gt; I want the leftmost selected column to be my horizontal axis, relative
gt;gt; gt;gt; to
gt;gt; gt;gt; which every other column is displayed. I also need to control the
gt;gt; gt;gt; scale
gt;gt; gt;gt; of
gt;gt; gt;gt; the vertical axis, but quot;helpquot; doesn't help with that either.
gt;gt; gt;gt;
gt;gt; gt;gt; How can I do this?
gt;gt; gt;gt;
gt;gt; gt;gt; Richard
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Keep in mind that a Line chart in Excel does not mean that the points are
connected by a line. Markers and lines are artifacts of formatting in Line
and XY charts. Line charts are distinguished by XY charts by their very
different X axis behavior, which I described above.
In 99% of cases, if the X data is numeric, the user should use an XY chart.
Notice that you can connect the points in an XY chart with a line the same
as in a Line chart. But the axis treats the X data as actual numerical data,
not merely slots in a row (your numbers might as well be row numbers for all
the numerical values mean to the Line chart).
More explanation:
pubs.logicalexpressions.com/P...cle.asp?ID=190
peltiertech.com/Excel/ChartsH...ValueAxis.html
- 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;Richard Erlacherquot; gt; wrote in message
...
gt; Jon,
gt;
gt; This is supposed to be a line chart. I have several lines I want to have
gt; appear, the leftmost of which is intended to be the X-axis.
gt; Unfortunately, instead of this, XL is using the row numbers on the left
gt; margin of the page, which is not helpful. It works as well, I guess as an
gt; XY chart. That way I get what I want to show.
gt;
gt; Thanks for the help.
gt;
gt; regards,
gt;
gt; Richard
gt;
gt; quot;Jon Peltierquot; gt; wrote in message
gt; ...
gt;gt; Do you want a line chart, or an XY chart? Is there any numerical
gt;gt; significance to the numbers? A line chart will plot them as labels in the
gt;gt; order they appear in the worksheet, uniformly spaced across the bottom of
gt;gt; the chart, without regard to the value of the numbers. An XY chart plots
gt;gt; X as a value vs. Y as a value. An XY chart will also automatically use
gt;gt; the first column for X values, while a line chart only does sometimes.
gt;gt;
gt;gt; You also asked about scaling the Y axis. Double click on it, click on the
gt;gt; Scale tab, then enter values you prefer to the automatic values Excel
gt;gt; computes. Don't check the boxes in front of the numbers after you change
gt;gt; them (seems silly, but lots of people do this and wonder why their
gt;gt; entries are ignored).
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;Richard Erlacherquot; gt; wrote in
gt;gt; message ...
gt;gt;gt; Nope, these are all numbers. However, it's the row-numbers that are
gt;gt;gt; currently appearing on the x-axis of my chart, and it's the first
gt;gt;gt; columnt in my data set that I want used. I had the impression that if I
gt;gt;gt; select just the columns I want presented in my chart, XL will use the
gt;gt;gt; leftmost as the quot;defaultquot; x-axis.
gt;gt;gt;
gt;gt;gt; The problem isn't that it's not using data I do want used, but, rather,
gt;gt;gt; quite the opposite. Those line-numbers are meaningless on my chart and
gt;gt;gt; I want the vaules in my first column used instead.
gt;gt;gt;
gt;gt;gt; Regards,
gt;gt;gt;
gt;gt;gt; Richard
gt;gt;gt;
gt;gt;gt; quot;Tushar Mehtaquot; gt; wrote in
gt;gt;gt; message ...
gt;gt;gt;gt; If the first column contains text information, select any cell in the
gt;gt;gt;gt; range
gt;gt;gt;gt; you want charted, then click the Chart Wizard button. XL should use
gt;gt;gt;gt; the
gt;gt;gt;gt; first column as the x-axis values.
gt;gt;gt;gt;
gt;gt;gt;gt; If it doesn't you have two choices. Either delete the header of the
gt;gt;gt;gt; first
gt;gt;gt;gt; column, then follow the steps in the previous paragraph or in the 2nd
gt;gt;gt;gt; step of
gt;gt;gt;gt; the chart wizard click the Series tab and then set the first column as
gt;gt;gt;gt; the
gt;gt;gt;gt; Category (X) values.
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt; Regards,
gt;gt;gt;gt;
gt;gt;gt;gt; Tushar Mehta
gt;gt;gt;gt; www.tushar-mehta.com
gt;gt;gt;gt; Custom business solutions leveraging a multi-disciplinary approach
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Richard Erlacherquot; wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;gt; I wish to limit my chart to only the data I entered into the
gt;gt;gt;gt;gt; spreadsheet.
gt;gt;gt;gt;gt; How can I suppress the use of the row numbers as the x-axis on a line
gt;gt;gt;gt;gt; chart?
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; I want the leftmost selected column to be my horizontal axis, relative
gt;gt;gt;gt;gt; to
gt;gt;gt;gt;gt; which every other column is displayed. I also need to control the
gt;gt;gt;gt;gt; scale of
gt;gt;gt;gt;gt; the vertical axis, but quot;helpquot; doesn't help with that either.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; How can I do this?
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Richard
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
留言列表
