Excel 2003- Charts- date and time format on x-axis of XY chart
Trying to plot data from two columns: X-Axis: Column 1 is Date/Time (mm/dd/yy hh:mm, e.g. 11/21/06 13:10),
Y-Axis: Column 2 is pH (number to 2 decimal places, e.g. 8.24).
1 - I do not know what DATA RANGE is and not sure what I should be highlighting/selecting for data range.
2 - Can not get Date/Time data in column 1 to show properly on X axis of
chart.will show date but not time so all points are lumped into one area on top of each other.number format for chart and data have been changed to be
I have a spreadsheet with dates in column A and times in column B (when data was gathered). I have a chart using the x-axis for column A (date). How can
I also get the chart to display the time? Basically, right now the x-axis is in the format 09/24/06 but I would like for it to be in the format 09/24/06 at 12:00 (or something like that). Can I use a custom number format that pulls data from multiple spreadsheet columns?
I am creating a chart monitoring (my dog's) breathing rate over time. I cannot check the rate at the same time each day so data entries are at different times of day.
I have the date column in my spreadsheet in the format dd/mm/yy hh:mm
When I go to make a simple line chart, if the horizontal axis is in date format, it only resolve the day part of the information, and so all my data for each day appears in the one horizontal place.
I can set the axis as text type, and I can then see each data point ok - but it does not reflect the time element of my data.
Please can you advise me how to get around this?
I am trying to create a line chart but am having trouble with labeling the X-Axis. The graph is charting temperature on the y-Axis and the date and time of the testing is running along the X-Axis. There are at least 1096
time entries and I would like the X-axis labels to only display the date which is only two days and not the time (reason for all the entries). The X-Axis is currently displaying the time at a 90 degree angle and only one date at an 180 degree angle, because of the numerous time entries the second date does not show up along the X-Axis.
I'm using Excel 97 SR-2 on a Windows XP machine with the date format under
Regional Settings set to dd/mm/yy.
I have a simple line chart (on a chart sheet) drawing data (date on X-axis and data on Y-axis) from three different worksheets, and am experiencing a problem with the dates on it randomly changing format from dd/mm/yy to m/d/yy. This is despite the fact that the dates in the worksheets are in dd/mm/yy format, and I have formatted the chart X-axis in that format also. Interestingly, if I click from the chart to one of the worksheets then back to the chart, the dates "correct" themselves (ie, show in dd/mm/yy format again).
If anyone can provide an explanation, and preferably a 'fix', I would love
Related Applications & Scripts
Create your own Google Chart and this jQuery plugin will transform it into a zoomable scrollable chart!
It creates a smaller chart that is not zoomed-in below. Then, using your mouse, you can zoom in and scroll across the x axis.
You can even pass in a date range for the x axis and it will create the x axis labels for you. Thats something that the Google Chart API doesnt provide you. Then, you can also pass in a date just like you do in PHP to get the labels formatted just the way you want.
You have complete control over the styles and colors. The Google Chart API allows you to customize any colors, fonts, etc. in the graphs and every generated HTML element has a class applied for easy CSS styling (it only generates 9 elements).
Do you want to create charts in flash? There is a need in software for Flash chart making?
Download Animated Chart software for creating charts in Flash! Flash chart animation is a great solution for your business visualization!
Animated Chart generates animation charts as movies in Adobe (Macromedia) Flash format for publishing them to web sites.
XML Animated Points Chart is completely generated in AS code using XML information
- You can set from AS the colors for caption and tool tip text
- You can edit general properties from XML
- The position of the chart.
- The width and height of the chart.
- Also can animate in a synchronized movement.
- Position for the captions
- Minimum and maximum values for Y axis.
- Interval value for grids in Y axis.
- Space between periods.
- Also can edit for each serie (XML)
- Light and Dark color for each serie
- Line color of the points
- The caption of the series
- You can add more periods and more series.
XML driven, completes my personal charts collection. This is an ideal complement for XML Animated Charts Package.
Flash Chart Package V2 includes new charts:
- Doughnut Chart
- Scattered Points Chart
- Bubbles Chart
- Stock Chart
- Horizontal Bars Chart
- Horizontal Stacked Bars Chart
- Horizontal Bars Chart V2
- Horizontal Bars Chart V3
This component displays current Date and Time. The background image, color and fonts are configurable in XML and CSS. Supports two modes.
- Displays current date and time.
- Supports two modes.
- Display time in 24 Hours or 12 Hours format.
- Configurable background image, color and fonts used.