Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
LINE-Column graph - I want 1 column multiple lines
Hello,
MS EXCEL 2003 on XP PRO. I want to create a graph with 3 series. I want one to be a Column and the other two to be lines. I use LINE-COLUMN out of the custom graph types and it forces the second data set to a column. Is there a legit way around it? Right now I'm including a dummy dataset in that #2 spot. Then deleting the key in the legend. There has to be a more legit way to do this. Thanks! -- BlueWolverine MSE - Mech. Eng. Go BLUE! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
LINE-Column graph - I want 1 column multiple lines
Hi,
You can prevent Excel from starting the chart this way if you choose Line-Column but you can alway change the chart type of any series anytime. So select on of the columns series on the chart that you want to be a line and choose Chart, Chart Type and pick Line... Of course you can convert a line to a column also. If this helps, please click the Yes button Cheers, Shane Devenshire "BlueWolverine" wrote: Hello, MS EXCEL 2003 on XP PRO. I want to create a graph with 3 series. I want one to be a Column and the other two to be lines. I use LINE-COLUMN out of the custom graph types and it forces the second data set to a column. Is there a legit way around it? Right now I'm including a dummy dataset in that #2 spot. Then deleting the key in the legend. There has to be a more legit way to do this. Thanks! -- BlueWolverine MSE - Mech. Eng. Go BLUE! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
LINE-Column graph - I want 1 column multiple lines
That's the money! I thought it would be under format data series. THANKS!
-- BlueWolverine MSE - Mech. Eng. Go BLUE! "Shane Devenshire" wrote: Hi, You can prevent Excel from starting the chart this way if you choose Line-Column but you can alway change the chart type of any series anytime. So select on of the columns series on the chart that you want to be a line and choose Chart, Chart Type and pick Line... Of course you can convert a line to a column also. If this helps, please click the Yes button Cheers, Shane Devenshire "BlueWolverine" wrote: Hello, MS EXCEL 2003 on XP PRO. I want to create a graph with 3 series. I want one to be a Column and the other two to be lines. I use LINE-COLUMN out of the custom graph types and it forces the second data set to a column. Is there a legit way around it? Right now I'm including a dummy dataset in that #2 spot. Then deleting the key in the legend. There has to be a more legit way to do this. Thanks! -- BlueWolverine MSE - Mech. Eng. Go BLUE! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Chart Line-Column ( 3 Lines 1 -column ) | Charts and Charting in Excel | |||
Change line to bar in Line - Column graph | Charts and Charting in Excel | |||
graph with one column and two lines | Excel Discussion (Misc queries) | |||
Excel graph column and two lines. Help | Charts and Charting in Excel | |||
How do I change column into lines on a Line-Column chart? | Charts and Charting in Excel |