Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting Dated Data
I have a small file, using only 6 rows and 6 columns. A1 has the word Date
in it, A2 through A6 has the dates, 1/1/08, 1/8/08, 1/15/08, 1/22/08, and 1/29/08. B2 through B6 has person's names and the cells from B2 through E6 contains numerical data. I am attempting to create a column chart, with the weekly dates on the X axis and the names in the legend, each column represents an individual. The problem is I am getting a lot of dates between the entered dates, every other day is showing up on the X axis, cluttering up the axis and setting the column widths very narrow. The gap width is around 10. I need to supress those unwanted dates and widen the columns in the chart. Any suggestions to explain this behaviour. Thank you Marsh |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting Dated Data
Correction, that is B1 through E1 that contains the names. I was thinking
ahead "Marsh" wrote: I have a small file, using only 6 rows and 6 columns. A1 has the word Date in it, A2 through A6 has the dates, 1/1/08, 1/8/08, 1/15/08, 1/22/08, and 1/29/08. B2 through B6 has person's names and the cells from B2 through E6 contains numerical data. I am attempting to create a column chart, with the weekly dates on the X axis and the names in the legend, each column represents an individual. The problem is I am getting a lot of dates between the entered dates, every other day is showing up on the X axis, cluttering up the axis and setting the column widths very narrow. The gap width is around 10. I need to supress those unwanted dates and widen the columns in the chart. Any suggestions to explain this behaviour. Thank you Marsh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank vs. 0 when plotting a dated timescale graph | Excel Worksheet Functions | |||
In Excel can you have a cell generate the last dated modified?? | Excel Discussion (Misc queries) | |||
print spreadsheet with each coming day dated on it for 2006. | Excel Discussion (Misc queries) | |||
Automatically creating the correct number of dated columns | Excel Discussion (Misc queries) | |||
Alternatives for Excel for charting dated time-series? | Charts and Charting in Excel |