Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Discontinuous X axis
I am trying to plot a series of data that has values at 1 hour, 2 hours, 4
hours, and 24 hours. Is there a way to plot it so that the data for the first four hours isn't squished against the right side? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Discontinuous X axis
Hi,
If you are not worry about the spacing between points being a true representation of the distance then change the axis type to Category instead of Time series. Right click the chart and choose Chart Options from the popup menu. On the Axis tab change the axis type. Cheers Andy genscientist wrote: I am trying to plot a series of data that has values at 1 hour, 2 hours, 4 hours, and 24 hours. Is there a way to plot it so that the data for the first four hours isn't squished against the right side? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Discontinuous X axis
Thanks for the advice Andy. Worked great!
:-) "Andy Pope" wrote: Hi, If you are not worry about the spacing between points being a true representation of the distance then change the axis type to Category instead of Time series. Right click the chart and choose Chart Options from the popup menu. On the Axis tab change the axis type. Cheers Andy genscientist wrote: I am trying to plot a series of data that has values at 1 hour, 2 hours, 4 hours, and 24 hours. Is there a way to plot it so that the data for the first four hours isn't squished against the right side? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Discontinuous X axis
Hi Andy -
In general, the time scale doesn't recognize times, only integral numbers of days. In other words, it's a date-scale axis. But if it's a line chart anyway, it could still behave as you suggest. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Andy Pope" wrote in message ... Hi, If you are not worry about the spacing between points being a true representation of the distance then change the axis type to Category instead of Time series. Right click the chart and choose Chart Options from the popup menu. On the Axis tab change the axis type. Cheers Andy genscientist wrote: I am trying to plot a series of data that has values at 1 hour, 2 hours, 4 hours, and 24 hours. Is there a way to plot it so that the data for the first four hours isn't squished against the right side? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel |