| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
use a time value in a bar graph
i have values in a series
like c5 9:01 d5 21:01 e5 =(d5-c5) I would like to use e5 in a bar graph it gives values which would make sense only to excel |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
use a time value in a bar graph
If the axis is formatted as time, it shouldn't be a problem. If it doesn't
choose the scales to give clean divisions, you can choose an appropriate unit on the axis, such as 03:00. -- David Biddulph "pdfrone" wrote in message ... i have values in a series like c5 9:01 d5 21:01 e5 =(d5-c5) I would like to use e5 in a bar graph it gives values which would make sense only to excel |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
use a time value in a bar graph
thanks do you know how to set the scale in vba or vb.net "David Biddulph" wrote: If the axis is formatted as time, it shouldn't be a problem. If it doesn't choose the scales to give clean divisions, you can choose an appropriate unit on the axis, such as 03:00. -- David Biddulph |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
use a time value in a bar graph
Turn on the macro recorder while you adjust the scale manually to get an
inefficient version of the VBA code. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "pdfrone" wrote in message ... thanks do you know how to set the scale in vba or vb.net "David Biddulph" wrote: If the axis is formatted as time, it shouldn't be a problem. If it doesn't choose the scales to give clean divisions, you can choose an appropriate unit on the axis, such as 03:00. -- David Biddulph |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
use a time value in a bar graph
thanks a lot problem solved. Went through the related link on your site and got the required code. pdfr "Jon Peltier" wrote: Turn on the macro recorder while you adjust the scale manually to get an inefficient version of the VBA code. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "pdfrone" wrote in message ... thanks do you know how to set the scale in vba or vb.net "David Biddulph" wrote: If the axis is formatted as time, it shouldn't be a problem. If it doesn't choose the scales to give clean divisions, you can choose an appropriate unit on the axis, such as 03:00. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XY graph to show date and time | Charts and Charting in Excel | |||
| Scaling time on the x-axis of a graph | Excel Discussion (Misc queries) | |||
| plot 4 time series in a common graph | Excel Discussion (Misc queries) | |||
| day of week and time on X axis of a graph | Charts and Charting in Excel | |||
| Time line in excel graph | Charts and Charting in Excel | |||
Linear Mode
