Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Date/Time on X axis

Hi,

As I'm moving from Excel 2003 to 2010, I'm struggling with a simple
graph. I want to plot measures over time, where each measure is made
at a specific date and time:


Date/Time |Ser1 |Ser2 |Ser3
20/06/2011 20:34 |23 |412 |21
21/06/2011 07:22 |441 |414 |535
21/06/2011 19:18 |52 |525 |525
21/06/2011 21:06 |646 |7 |7453
22/06/2011 07:00 |65 |5645 |5445
22/06/2011 18:32 |8789 |889 |45
22/06/2011 21:18 |67 |65 |765
23/06/2011 06:44 |123 |84 |65

The chart I get from the wizard only keeps one entry in the X axis per
day, discounting the exact time. How can I force to keep the data/hour/
minute units on my X axis?

Thanks!

mrgou
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 833
Default Date/Time on X axis

On Jun 24, 12:06*pm, mrgou wrote:
Hi,

As I'm moving from Excel 2003 to 2010, I'm struggling with a simple
graph. I want to plot measures over time, where each measure is made
at a specific date and time:

Date/Time * * * * * * * |Ser1 * |Ser2 * |Ser3
20/06/2011 20:34 * * * *|23 * * |412 * *|21
21/06/2011 07:22 * * * *|441 * *|414 * *|535
21/06/2011 19:18 * * * *|52 * * |525 * *|525
21/06/2011 21:06 * * * *|646 * *|7 * * *|7453
22/06/2011 07:00 * * * *|65 * * |5645 * |5445
22/06/2011 18:32 * * * *|8789 * |889 * *|45
22/06/2011 21:18 * * * *|67 * * |65 * * |765
23/06/2011 06:44 * * * *|123 * *|84 * * |65

The chart I get from the wizard only keeps one entry in the X axis per
day, discounting the exact time. How can I force to keep the data/hour/
minute units on my X axis?

Thanks!

mrgou




Please refer to:-

http://www.pierrefondes.com/

Item 132 (toward the top of my home page).

I think that what I have done (in EXCEL 2007) matches your
requirements.
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 833
Default Date/Time on X axis

On Jun 24, 12:06*pm, mrgou wrote:
Hi,

As I'm moving from Excel 2003 to 2010, I'm struggling with a simple
graph. I want to plot measures over time, where each measure is made
at a specific date and time:

Date/Time * * * * * * * |Ser1 * |Ser2 * |Ser3
20/06/2011 20:34 * * * *|23 * * |412 * *|21
21/06/2011 07:22 * * * *|441 * *|414 * *|535
21/06/2011 19:18 * * * *|52 * * |525 * *|525
21/06/2011 21:06 * * * *|646 * *|7 * * *|7453
22/06/2011 07:00 * * * *|65 * * |5645 * |5445
22/06/2011 18:32 * * * *|8789 * |889 * *|45
22/06/2011 21:18 * * * *|67 * * |65 * * |765
23/06/2011 06:44 * * * *|123 * *|84 * * |65

The chart I get from the wizard only keeps one entry in the X axis per
day, discounting the exact time. How can I force to keep the data/hour/
minute units on my X axis?

Thanks!

mrgou




Please refer to:-

http://www.pierrefondes.com/

- item 132 (towards the top of my home page).

I think that what I have done (in EXCEL 2007) matches your
requirements.
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 833
Default Date/Time on X axis

On Jun 24, 12:06*pm, mrgou wrote:
Hi,

As I'm moving from Excel 2003 to 2010, I'm struggling with a simple
graph. I want to plot measures over time, where each measure is made
at a specific date and time:

Date/Time * * * * * * * |Ser1 * |Ser2 * |Ser3
20/06/2011 20:34 * * * *|23 * * |412 * *|21
21/06/2011 07:22 * * * *|441 * *|414 * *|535
21/06/2011 19:18 * * * *|52 * * |525 * *|525
21/06/2011 21:06 * * * *|646 * *|7 * * *|7453
22/06/2011 07:00 * * * *|65 * * |5645 * |5445
22/06/2011 18:32 * * * *|8789 * |889 * *|45
22/06/2011 21:18 * * * *|67 * * |65 * * |765
23/06/2011 06:44 * * * *|123 * *|84 * * |65

The chart I get from the wizard only keeps one entry in the X axis per
day, discounting the exact time. How can I force to keep the data/hour/
minute units on my X axis?

Thanks!

mrgou



Please see:-

http://www.pierrefondes.com/

Item 132.
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
xy scatter with date/time as x axis maryj Charts and Charting in Excel 2 May 3rd 07 09:21 PM
Chart with x-axis as date/time UnderCoverGuy Charts and Charting in Excel 2 September 25th 06 01:44 PM
Discretionary X-axis (for date & time) Frank Charts and Charting in Excel 2 September 24th 06 06:16 PM
Date & Time on X Axis gamala Charts and Charting in Excel 5 September 21st 06 07:00 PM
Date and Time on X-axis cdoughty Charts and Charting in Excel 4 August 24th 05 02:35 PM


All times are GMT +1. The time now is 06:39 PM.

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

About Us

"It's about Microsoft Excel"