Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
This seems like it may be a simple thing, yet I can not for the life of me figure out how to do this (or at least semi-easily with VBing it for a while). I have a simple table filled with the following information (example for simplicity): 12pm 5pm 10pm 11/20 5 4 7 11/21 5 4 7 11/23 5 4 7 11/24 5 4 7 11/25 5 4 7 So basically I am keeping track of a numeric value three times a day. I would like to make a chart of it with one series with one long line for the whole month tracking those numeric values. The chart would have x-axis as date/time and y-axis with values(1-9). So there needs to be 3 entries for every day on the x-axis tracking all of these numbers. I have juggled different designs all over the place and can not get this to work. Any help would be appreciated. Thanks, Marc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
How to make a chart from a list of names? | Charts and Charting in Excel | |||
how to make a chart with data from all the pages in a workbook? | Charts and Charting in Excel | |||
how do i make a "dashboard style" chart (semi circle & pointer) | Charts and Charting in Excel | |||
If I have data for varying times in a column chart, how do I space | Charts and Charting in Excel |