PC Review


Reply
Thread Tools Rate Thread

Adjusting X-axis scale on chart

 
 
John
Guest
Posts: n/a
 
      30th Mar 2004
I created a simple line chart in PP2000 and am having
trouble with the X-axis scale.

The x-axis measures time over a 24 hour period but the
readings are not uniformly spaced. I have readings at 30
min, 1 hr, 90 min, 2 hr, 4, 6, 8, 12, 18 and 24 hrs.

The chart, however, spaces these time points uniformly so
that the space between the 30 & 60 minutes points is the
same as the space between the 18 & 24 hour points.

How can I scale this so they appear at the proper
intervals? I tried changing the values from General to
Numbers and to Times but it doesn't seem to help the
spacing intervals.
 
Reply With Quote
 
 
 
 
TAJ Simmons
Guest
Posts: n/a
 
      30th Mar 2004
John,

You'll have to have the x axis go from
0 to 24 hours at a 30 min interval.
Then enter your values at the appropriate points.

0:0
0:30 12.3
1:00 22.4
1:30 (aka 90 mins) 33.2
2:00 75.2
2:30
3:00
4:00 64.2
etc
etc

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
free powerpoint templates, tutorials, hints and tips etc
http://www.powerpointbackgrounds.com


 
Reply With Quote
 
Guest
Posts: n/a
 
      30th Mar 2004
Thanks, but this method leaves gaps in my line where the
blank values are. Is there a way to connect the points
across these empty values?

John

>-----Original Message-----
>John,
>
>You'll have to have the x axis go from
>0 to 24 hours at a 30 min interval.
>Then enter your values at the appropriate points.
>
>0:0
>0:30 12.3
>1:00 22.4
>1:30 (aka 90 mins) 33.2
>2:00 75.2
>2:30
>3:00
>4:00 64.2
>etc
>etc
>
>Cheers
>TAJ Simmons
>microsoft powerpoint mvp
>
>awesome - powerpoint backgrounds,
>free powerpoint templates, tutorials, hints and tips etc
>http://www.powerpointbackgrounds.com
>
>
>.
>

 
Reply With Quote
 
TAJ Simmons
Guest
Posts: n/a
 
      30th Mar 2004
The only way I ever sorted that problem was to work out the values....very tedious!

If anyone else has a solution please post it here

Cheers
TAJ


 
Reply With Quote
 
Echo S
Guest
Posts: n/a
 
      31st Mar 2004
Make the blank value a zero, then drag the point into place on the graph.
Click to select only that data point and remove the marker itself.

Or maybe use a scatter chart if the timeseries doesn't need to be in scale.

--
Echo [MS PPT MVP]

"TAJ Simmons" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The only way I ever sorted that problem was to work out the values....very

tedious!
>
> If anyone else has a solution please post it here
>
> Cheers
> TAJ
>
>



 
Reply With Quote
 
TAJ Simmons
Guest
Posts: n/a
 
      31st Mar 2004
>then drag the point into place on the graph.
I didn't know you could do that..... That's a top tip!

Cheers
TAJ

"Echo S" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> Make the blank value a zero, then drag the point into place on the graph.
> Click to select only that data point and remove the marker itself.
>
> Or maybe use a scatter chart if the timeseries doesn't need to be in scale.
>
> --
> Echo [MS PPT MVP]
>
> "TAJ Simmons" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > The only way I ever sorted that problem was to work out the values....very

> tedious!
> >
> > If anyone else has a solution please post it here
> >
> > Cheers
> > TAJ
> >
> >

>
>



 
Reply With Quote
 
Steve Rindsberg
Guest
Posts: n/a
 
      31st Mar 2004

John,

Activate the chart, then choose Tools, Options.
In the Graph Options dialog box, click the Chart tab.
"Empty cells plotted as" will probably be "Not plotted" by default
Choose Interpolated instead.

That may turn Smooted Line in the series formatting options on by default. You
can turn it off if you like straight lines.



--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com

 
Reply With Quote
 
Echo S
Guest
Posts: n/a
 
      1st Apr 2004
"Steve Rindsberg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> John,
>
> Activate the chart, then choose Tools, Options.
> In the Graph Options dialog box, click the Chart tab.
> "Empty cells plotted as" will probably be "Not plotted" by default
> Choose Interpolated instead.


Dang. I *knew* there was a setting for that, but I didn't have time to look
for it!

--
Echo [MS PPT MVP]
http://www.echosvoice.com


 
Reply With Quote
 
Steve Rindsberg
Guest
Posts: n/a
 
      1st Apr 2004
>
> Dang. I *knew* there was a setting for that, but I didn't have time to look
> for it!


You cover mine, I cover yours. I think I learned about it from a post of
yours. ;-)

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com

 
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adjusting Y axis scale of a chart using a scrollbar? Brad Microsoft Excel Programming 9 23rd Jun 2009 08:21 AM
Adjusting log scale on the x-axis SuzukiPilot Microsoft Excel Worksheet Functions 0 10th Jun 2009 01:27 PM
How to draw chart: log scale on X axis, natural scale on y axis? =?Utf-8?B?UHJhdGFwIEQuIGNoYXZhbg==?= Microsoft Excel Charting 1 16th Nov 2006 08:03 AM
adjusting chart axis scale =?Utf-8?B?bmVlcmFq?= Microsoft Access 0 22nd Dec 2005 08:01 PM
adjusting scale on category axis on chart =?Utf-8?B?amFuYWtp?= Microsoft Access Reports 0 21st Oct 2005 03:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:16 AM.