PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting How do I get the category axis units to be in even increments?

Reply

How do I get the category axis units to be in even increments?

 
Thread Tools Rate Thread
Old 01-04-2006, 07:34 PM   #1
=?Utf-8?B?Tmljb2NhbGE=?=
Guest
 
Posts: n/a
Default How do I get the category axis units to be in even increments?


I have a titration curve that has volume of NaOH added on the category axis.
The units are going from 0.6 to 1.0 to 1.6 to 1.9 in crazy increments.
There's no rhyme or reason between units, so it's messing up my graph. I've
tried everthing to try to make the units go in uniform (0.5, 1.0, 1.5 etc)
units with my data points wherever inbetween, but nothing is working! Please
help!
  Reply With Quote
Old 01-04-2006, 09:38 PM   #2
Kelly O'Day
Guest
 
Posts: n/a
Default Re: How do I get the category axis units to be in even increments?

Nicocala:

What type of chart are you using? it sounds like you are using a Line Chart.

You want to use an XY chart.

To check on which type of chart, activate your chart, press Chart > Chart
type on toolbar.Your chart type will be highlighted. XY charts are 2 below
Line charts on the Chart type dialog.

..Kelly

koday@processtrends.com




"Nicocala" <Nicocala@discussions.microsoft.com> wrote in message
news:C1A26396-4EF8-4FD9-A0C7-280C7A07D37B@microsoft.com...
>I have a titration curve that has volume of NaOH added on the category
>axis.
> The units are going from 0.6 to 1.0 to 1.6 to 1.9 in crazy increments.
> There's no rhyme or reason between units, so it's messing up my graph.
> I've
> tried everthing to try to make the units go in uniform (0.5, 1.0, 1.5 etc)
> units with my data points wherever inbetween, but nothing is working!
> Please
> help!



  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off