Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / July 2006

Tip: Looking for answers? Try searching our database.

How do I define X-axis stepping?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChrisCasey - 21 Jul 2006 01:36 GMT
Hi,

I would like to chart some data.  For illustrative purposes, let's sa
that it looks like this:

Code
-------------------
   MONEY DONORS
 (X) (Y)
 $1000   5
 $50   7
 $1  2
-------------------

I would like to make an Area Graph of the data.  However, when I d
this, the X axis is divided into three even parts, one for $1000, on
for $50, and one for $1 -- that is to say, the gap between $1 and $5
is the same size as the gap between $50 and $1000.  I would instea
like to see the width of the graph dedicated to the full range o
possible values, $1 to $1000, with the midpoint being $500 (and thu
the datapoint for $50 very near to the one for $1, on the right).

Can this be done easily in Excel, or should I find a separate chartin
package?

(In actuality, I have about 100 X-values in the range of 500 to 4000)

Thanks for any help,
Chri
Tushar Mehta - 21 Jul 2006 13:24 GMT
Select the chart, then select Chart | Chart Options... | Axes tab.  In
there, set the Category (X) axis to 'Time scale.'

Subsequently, you may have to adjust the format of the x-axis and set the
Number format by hand (double-click the x-axis, then click the Number tab).

That said, I am not sure an Area Chart is the ideal way to represent this
data set.  You may want to look at a Column chart (or even a Bar chart).

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Hi,
>
[quoted text clipped - 25 lines]
> Thanks for any help,
> Chris
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.