|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 22nd, 2010, 06:28 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Connection Lines Between Data Points
I'm trying to show connecting lines between data points. X axis is in
dollars for the days of the week, Y axis is date. I do not have figures for each day for the X axis, so my data points will not connect. Below is an example of my data. Any help is appreciated. Thank you! Date Monday Tuesday Wednesday Thursday 12/1 $1,169 12/2 $521 12/3 $2,321 12/4 12/5 12/6 12/7 $3,317 12/8 $2,791 12/9 $776 12/10 $4,772 12/11 12/12 12/13 12/14 $1,391 12/15 $1,501 12/16 $1,322 12/17 $3,688 12/18 12/19 12/20 12/21 $4,403 12/22 $1,415 12/23 $1,327 12/24 12/25 12/26 12/27 12/28 $1,885 12/29 $1,768 12/30 $376 12/31 
|
|
#2
January 22nd, 2010, 06:51 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Connection Lines Between Data Points
Does chart have to be set up in way you propose?
Could it be a column chart with dates along the horizontal axis and USD amounts up the vertical axis? Are you specifically looking for a Line Chart? "CLR" wrote: I'm trying to show connecting lines between data points. X axis is in dollars for the days of the week, Y axis is date. I do not have figures for each day for the X axis, so my data points will not connect. Below is an example of my data. Any help is appreciated. Thank you! Date Monday Tuesday Wednesday Thursday 12/1 $1,169 12/2 $521 12/3 $2,321 12/4 12/5 12/6 12/7 $3,317 12/8 $2,791 12/9 $776 12/10 $4,772 12/11 12/12 12/13 12/14 $1,391 12/15 $1,501 12/16 $1,322 12/17 $3,688 12/18 12/19 12/20 12/21 $4,403 12/22 $1,415 12/23 $1,327 12/24 12/25 12/26 12/27 12/28 $1,885 12/29 $1,768 12/30 $376 12/31
|
|
#3
January 22nd, 2010, 07:43 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Connection Lines Between Data Points
Yes, it needs to be a line chart.
"trip_to_tokyo" wrote: Does chart have to be set up in way you propose? Could it be a column chart with dates along the horizontal axis and USD amounts up the vertical axis? Are you specifically looking for a Line Chart? "CLR" wrote: I'm trying to show connecting lines between data points. X axis is in dollars for the days of the week, Y axis is date. I do not have figures for each day for the X axis, so my data points will not connect. Below is an example of my data. Any help is appreciated. Thank you! Date Monday Tuesday Wednesday Thursday 12/1 $1,169 12/2 $521 12/3 $2,321 12/4 12/5 12/6 12/7 $3,317 12/8 $2,791 12/9 $776 12/10 $4,772 12/11 12/12 12/13 12/14 $1,391 12/15 $1,501 12/16 $1,322 12/17 $3,688 12/18 12/19 12/20 12/21 $4,403 12/22 $1,415 12/23 $1,327 12/24 12/25 12/26 12/27 12/28 $1,885 12/29 $1,768 12/30 $376 12/31
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
