LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 204
Default Linear time axis on line chart

Hello, I want to have a linear time axis along the bottom of my chart, and
to display some values associated with a series of events and to have their
position on the axis grouped and spaced by the time that they occured.

This means that if I had three things happen at 9:15, 9:30 and 10:00 on
monday, then another event at 9:00 on Tuesday, the values for the first
three would appear in quite close proximity along the axis, then a fairly
large gap before the next one. - does that make sense?

I can nearly get what I want with a scatter chart, but some of the events
will have one or two of the associated values missing and the scatter chart
leaves a gap where there is no value, instead of just linking it up with a
line to/from the previous one. And I need to show a continuous trend.

Is this possible?

Thank you for your help.

M

 
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
Line chart - time series - category axis date format (2007 VBA) Paul Jacob Charts and Charting in Excel 1 April 18th 09 03:10 AM
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed John Burke Charts and Charting in Excel 8 July 30th 07 03:10 PM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
stock chart non-linear y-axis Alseikhan Charts and Charting in Excel 2 March 28th 06 11:34 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM


All times are GMT +1. The time now is 01:07 AM.

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"