#1   Report Post  
Posted to microsoft.public.excel.charting
Annie
 
Posts: n/a
Default Charting Time

Hi
I have a temperature graph that I need to chart over time. From 0 to 168hrs
but the Log chart in Custom Types gives me even spaces between the times
which is not what I want .25mins to 168 hrs? If I was to plot the graph in
minutes it would be too vast - huge!
Is there any add-ins available to do this type of graph.

Thanks
--
Kind regards

Ann Shaw
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Charting Time

No add-ins necessary, just use Excel. You can put your data in decimal hours
if you want, or enter it as hh:mm format. Don't include text labels in the
same cell, or Excel will treat the times as categorical labels. Make an XY
chart, not a line chart, with the times as the X values and your other
variable as the values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Annie" wrote in message
...
Hi
I have a temperature graph that I need to chart over time. From 0 to
168hrs
but the Log chart in Custom Types gives me even spaces between the times
which is not what I want .25mins to 168 hrs? If I was to plot the graph
in
minutes it would be too vast - huge!
Is there any add-ins available to do this type of graph.

Thanks
--
Kind regards

Ann Shaw



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
charting how many widgets over time [email protected] Charts and Charting in Excel 3 May 1st 06 08:05 PM
Hot key for time? Dave in Des Moines New Users to Excel 2 March 24th 06 04:31 PM
Hot key for time? Dave in Des Moines Excel Worksheet Functions 2 March 24th 06 04:15 PM
Hot key for time? Dave in Des Moines Excel Discussion (Misc queries) 1 March 24th 06 03:46 PM
Charting time? help please... Gustavo Monteverde Charts and Charting in Excel 1 November 28th 04 04:53 AM


All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"