Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
How do I swich data from being displayed as a column rather than a line in a
Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
In the chart Select the series you want to change and then go to <chart
<chart type and select what you want it to do Each series can be different "Spyder" wrote: How do I swich data from being displayed as a column rather than a line in a Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
Right-click on the line you want to have displayed as a column, then select
"Chart Type" from the drop down box. Then walk through the wizard and modify the chart as you like. -- HTH JonR "Spyder" wrote: How do I swich data from being displayed as a column rather than a line in a Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
Thanks Jon,
I was able to change the data series from a line to a column by right-clicking the series and selecting <chart type then <column; however, the column overlaps the other three series which are displayed as columns. Any ideas on how I can get the series to display to the right of the last column rather than overlapping it and the others? Thanks, Jeff "JonR" wrote: Right-click on the line you want to have displayed as a column, then select "Chart Type" from the drop down box. Then walk through the wizard and modify the chart as you like. -- HTH JonR "Spyder" wrote: How do I swich data from being displayed as a column rather than a line in a Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
Right click on your column and select "Format Data Point"
There is an Options tab which will allow you to adjust the overlap and gap width. Play with these until you get the chart that pleases you. -- HTH JonR "Spyder" wrote: Thanks Jon, I was able to change the data series from a line to a column by right-clicking the series and selecting <chart type then <column; however, the column overlaps the other three series which are displayed as columns. Any ideas on how I can get the series to display to the right of the last column rather than overlapping it and the others? Thanks, Jeff "JonR" wrote: Right-click on the line you want to have displayed as a column, then select "Chart Type" from the drop down box. Then walk through the wizard and modify the chart as you like. -- HTH JonR "Spyder" wrote: How do I swich data from being displayed as a column rather than a line in a Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
try also right clicking on the new column and selecting the axis tab, change
to the other axis from the one curreently selected. "Spyder" wrote: Thanks Jon, I was able to change the data series from a line to a column by right-clicking the series and selecting <chart type then <column; however, the column overlaps the other three series which are displayed as columns. Any ideas on how I can get the series to display to the right of the last column rather than overlapping it and the others? Thanks, Jeff "JonR" wrote: Right-click on the line you want to have displayed as a column, then select "Chart Type" from the drop down box. Then walk through the wizard and modify the chart as you like. -- HTH JonR "Spyder" wrote: How do I swich data from being displayed as a column rather than a line in a Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
Next time, avoid the built-in custom types (with a name like "built-in
custom", they couldn't possibly work right), and build your own combination chart. Create the chart with all six series as the more prevalent type in the chart (columns). Select one series you want to change, do the Chart menu Chart Type thing that bj and JonR told you about, then select the other and use the F4 shortcut to repeat this action. Then double click one of the series you need on the secondary axis, and on the Axis tab, select Secondary, as bj described, then select the other and use the F4 shortcut to repeat this action. Building your own combination chart hardly takes longer than using the built-in ones, and you retain control over its individual series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Spyder" wrote in message ... How do I swich data from being displayed as a column rather than a line in a Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Custom Types - Line Column - Data Series
Spyder,
Jon Peltier is THE MAN. You will do yourself a huge favor by bookmarking his webpage. I refer to it often, especially when I need to 'wow' the boss. You'll learn a lot from him. I'm grateful there are people of his caliber willing to share knowledge. -- HTH JonR "Jon Peltier" wrote: Next time, avoid the built-in custom types (with a name like "built-in custom", they couldn't possibly work right), and build your own combination chart. Create the chart with all six series as the more prevalent type in the chart (columns). Select one series you want to change, do the Chart menu Chart Type thing that bj and JonR told you about, then select the other and use the F4 shortcut to repeat this action. Then double click one of the series you need on the secondary axis, and on the Axis tab, select Secondary, as bj described, then select the other and use the F4 shortcut to repeat this action. Building your own combination chart hardly takes longer than using the built-in ones, and you retain control over its individual series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Spyder" wrote in message ... How do I swich data from being displayed as a column rather than a line in a Line-Column chart? I have 6 data series and would like the first 4 in the chart displayed as columns and the second two as lines using the same y axis, but right now Excel has defaulted the first two as columns and the second two as lines and I cannot make the changes I need. Any thoughts? Thanks! Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i move data series into other columns on column charts | Charts and Charting in Excel | |||
2 data types (same col/dif times), do: custom? parse? 2col? | Excel Discussion (Misc queries) | |||
How do I share User-Defined Custom Chart Types in Pivot Charts? | Charts and Charting in Excel | |||
Charts Line Types for Multiple Data Series not Printing Properly | Charts and Charting in Excel | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |