Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timescale in Charts
Hi, I have created a line chart where the x-column is dates and the other
column (y-axis) is my data. However, the data is not put into this second column at regular intervals - I might go for, say, a month without entering any data, but then again I may go through a few weeks where I am entering data every day. This problem isn't really urgent to me as my line chart works fine, but just as a bonus I would like to see the data displayed proportionately over time (for example if difference between the 1st data point and last data point was exactly one year, I would like the midpoint of the graph to be 6 months). I have tried changing the options and reading the books etc but haven't had any joy so far. Any help appreciated, Sally |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
How To Change Fonts In Multiple Charts in a Workbook? | Charts and Charting in Excel | |||
Charts won't update | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) |