Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with x-axis as date/time
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? Thanks in advance for any help, UCG |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with x-axis as date/time
Combine the date and time into a single column (Excel stores these numbers
as a whole number date and fractional number time). This is now valid numerical data, which will work as you want in the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "UnderCoverGuy" wrote in message ... 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? Thanks in advance for any help, UCG |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with x-axis as date/time
I was afraid that I would have to do that (was hoping to avoid it). But oh
well, the end result is accomplished... Thanks, UCG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
negative [h]:mm:ss does not show on the x axis of a chart | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |