View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
Richard Erlacher
 
Posts: n/a
Default how can I limit my chart

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

"Tushar Mehta" wrote in message
...
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
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"Richard Erlacher" wrote:

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
"default" 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

"Tushar Mehta" wrote in message
...
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
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"Richard Erlacher" wrote:

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 "help" doesn't help with that either.

How can I do this?

Richard