Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line chart by day of week
Greetings all. In column B I have days of the week, and in column K I have
total drive time in seconds for my commute, for a total of five weeks. I have seen charts that plot points for each day of the week on a separate line. My chart would have the days of the week in the y axis, and the time in seconds on the x axis, and a separate line for each day. No matter how I try to set it up, it ends up looking like a jumbled mess. It should look like the below example, but I realize the lines will not be straight, and they will overlap, so will need to be different colors. Is this even possible? If so, does anyone know how to do it. I am thinking there will need to be a legend showing the color of the line for each day of the week, since they will be overlapping. Thank you. Monday | -------------------------------------------------------- Tuesday |-------------------------------------------------------- Wednesday |-------------------------------------------------------- Thursday |-------------------------------------------------------- Friday |-------------------------------------------------------- ___________________________________________ 1800 1850 1900 1950 2000 2050 2100 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line chart by day of week
I figured it out. Also realized I should have posted in the charts forum.
"Greg Snidow" wrote: Greetings all. In column B I have days of the week, and in column K I have total drive time in seconds for my commute, for a total of five weeks. I have seen charts that plot points for each day of the week on a separate line. My chart would have the days of the week in the y axis, and the time in seconds on the x axis, and a separate line for each day. No matter how I try to set it up, it ends up looking like a jumbled mess. It should look like the below example, but I realize the lines will not be straight, and they will overlap, so will need to be different colors. Is this even possible? If so, does anyone know how to do it. I am thinking there will need to be a legend showing the color of the line for each day of the week, since they will be overlapping. Thank you. Monday | -------------------------------------------------------- Tuesday |-------------------------------------------------------- Wednesday |-------------------------------------------------------- Thursday |-------------------------------------------------------- Friday |-------------------------------------------------------- ___________________________________________ 1800 1850 1900 1950 2000 2050 2100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Line Chart - Chart line to go directly to next value | Charts and Charting in Excel | |||
Chart daily data and add a trend line for each week | Charts and Charting in Excel | |||
How do I convert a line chart to a vertical line chart in Excel | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Line Chart with dates in 5 day working week only | Charts and Charting in Excel |