| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column-Line Chart w/ Dates
I have a chart that is using columns for category "A" on the primary x-axis
(a $ amount). This category is broken down first by person, then by month. So essentially from left to right the columns will be person "1" and month "1", person "1" and month "2", person "1" and month "3", person "2" and month "1", and so on.... The chart is also using lines to mark category "B" on the secondary x-axis (a $ amount that is a portion of category "A", but not a percentage. Essentially category "B" will never be larger than category "A".). This category is broken down in the same fashion as category "A" (first by person, then by month). The problem I'm running into is that the line for month "1", category "B" does not hover over month "1", category "A" column. All lines basically hover over the middle column month for each person. Is there any way to get each month line to hover over each month column? Thx! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Column-Line Chart w/ Dates
Try this:
http://peltiertech.com/Excel/Charts/...olAndLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Neutron1871" wrote in message ... I have a chart that is using columns for category "A" on the primary x-axis (a $ amount). This category is broken down first by person, then by month. So essentially from left to right the columns will be person "1" and month "1", person "1" and month "2", person "1" and month "3", person "2" and month "1", and so on.... The chart is also using lines to mark category "B" on the secondary x-axis (a $ amount that is a portion of category "A", but not a percentage. Essentially category "B" will never be larger than category "A".). This category is broken down in the same fashion as category "A" (first by person, then by month). The problem I'm running into is that the line for month "1", category "B" does not hover over month "1", category "A" column. All lines basically hover over the middle column month for each person. Is there any way to get each month line to hover over each month column? Thx! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Column-Line Chart w/ Dates
That worked great Jon!! I used the second method on your website to create
my chart. However, what is happening now is that the lines are connecting by month from person "1" to person "2" to person "3". I want the lines to connect by person from month "1" to month "2" to month "3". Is that possible? "Jon Peltier" wrote: Try this: http://peltiertech.com/Excel/Charts/...olAndLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Neutron1871" wrote in message ... I have a chart that is using columns for category "A" on the primary x-axis (a $ amount). This category is broken down first by person, then by month. So essentially from left to right the columns will be person "1" and month "1", person "1" and month "2", person "1" and month "3", person "2" and month "1", and so on.... The chart is also using lines to mark category "B" on the secondary x-axis (a $ amount that is a portion of category "A", but not a percentage. Essentially category "B" will never be larger than category "A".). This category is broken down in the same fashion as category "A" (first by person, then by month). The problem I'm running into is that the line for month "1", category "B" does not hover over month "1", category "A" column. All lines basically hover over the middle column month for each person. Is there any way to get each month line to hover over each month column? Thx! |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Column-Line Chart w/ Dates
Rearrange the data so that all points you want to link by a line are in the
same series, i.e., in the same column of the worksheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Neutron1871" wrote in message ... That worked great Jon!! I used the second method on your website to create my chart. However, what is happening now is that the lines are connecting by month from person "1" to person "2" to person "3". I want the lines to connect by person from month "1" to month "2" to month "3". Is that possible? "Jon Peltier" wrote: Try this: http://peltiertech.com/Excel/Charts/...olAndLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Neutron1871" wrote in message ... I have a chart that is using columns for category "A" on the primary x-axis (a $ amount). This category is broken down first by person, then by month. So essentially from left to right the columns will be person "1" and month "1", person "1" and month "2", person "1" and month "3", person "2" and month "1", and so on.... The chart is also using lines to mark category "B" on the secondary x-axis (a $ amount that is a portion of category "A", but not a percentage. Essentially category "B" will never be larger than category "A".). This category is broken down in the same fashion as category "A" (first by person, then by month). The problem I'm running into is that the line for month "1", category "B" does not hover over month "1", category "A" column. All lines basically hover over the middle column month for each person. Is there any way to get each month line to hover over each month column? Thx! |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Column-Line Chart w/ Dates
You are an Excel Genius, thank you!!!
"Jon Peltier" wrote: Rearrange the data so that all points you want to link by a line are in the same series, i.e., in the same column of the worksheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Neutron1871" wrote in message ... That worked great Jon!! I used the second method on your website to create my chart. However, what is happening now is that the lines are connecting by month from person "1" to person "2" to person "3". I want the lines to connect by person from month "1" to month "2" to month "3". Is that possible? "Jon Peltier" wrote: Try this: http://peltiertech.com/Excel/Charts/...olAndLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Neutron1871" wrote in message ... I have a chart that is using columns for category "A" on the primary x-axis (a $ amount). This category is broken down first by person, then by month. So essentially from left to right the columns will be person "1" and month "1", person "1" and month "2", person "1" and month "3", person "2" and month "1", and so on.... The chart is also using lines to mark category "B" on the secondary x-axis (a $ amount that is a portion of category "A", but not a percentage. Essentially category "B" will never be larger than category "A".). This category is broken down in the same fashion as category "A" (first by person, then by month). The problem I'm running into is that the line for month "1", category "B" does not hover over month "1", category "A" column. All lines basically hover over the middle column month for each person. Is there any way to get each month line to hover over each month column? Thx! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to have a Line - Stacked Column Chart? | Charts and Charting in Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Line Chart with dates in 5 day working week only | Charts and Charting in Excel | |||
Hybrid Mode
