Graph Trouble

brettvba · May 26th, 2002, 03:14 PM

I have some data
column 1 has weeks
Column 2 has 5 didgit numbers
Column 3 has two digit numbers
Column 4 has a target in a two digit number

Column 1 is along the bottom

Using Custom Types
Line -Column on two axes

My original graph worked fine with just the first 3 columns but when i added the target it stuffs the graph up I want a bar for column 2 and lines for 3 and 4 can anyone tell me why when I add the target(Column4) that Column 3 then turns into a stacked bar?

Hopefully I have explained myself well enuf for one of you to help me

Thanks

VisLord · May 26th, 2002, 04:33 PM

Do not understand,

is this a graph ??

brettvba · May 26th, 2002, 04:45 PM

perhaps i should rephrase the question

Im trying to create a graph with a bar and 2 lines on a double axes graph

My question is the above and can you create your own graphs somehow?

PaddyD · May 26th, 2002, 05:19 PM

Brett,

Couldn't replicate your problem?!? Have you tried selecting the offending series in the chart, right click &change the chart type for that series?

Paddy

brettvba · May 26th, 2002, 05:25 PM

yeah I have now fixed the problem after alot of bother couldn't select the other bar to change it to a line but after consulting someone else in my workplace it got fixed thanks guys

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 26th, 2002, 03:14 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	I have some data column 1 has weeks Column 2 has 5 didgit numbers Column 3 has two digit numbers Column 4 has a target in a two digit number Column 1 is along the bottom Using Custom Types Line -Column on two axes My original graph worked fine with just the first 3 columns but when i added the target it stuffs the graph up I want a bar for column 2 and lines for 3 and 4 can anyone tell me why when I add the target(Column4) that Column 3 then turns into a stacked bar? Hopefully I have explained myself well enuf for one of you to help me Thanks

May 26th, 2002, 04:33 PM	#2
VisLord New Member Join Date: Apr 2002 Posts: 30	Do not understand, is this a graph ??

May 26th, 2002, 04:45 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	perhaps i should rephrase the question Im trying to create a graph with a bar and 2 lines on a double axes graph My question is the above and can you create your own graphs somehow?

May 26th, 2002, 05:19 PM	#4
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Brett, Couldn't replicate your problem?!? Have you tried selecting the offending series in the chart, right click &change the chart type for that series? Paddy

May 26th, 2002, 05:25 PM	#5
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	yeah I have now fixed the problem after alot of bother couldn't select the other bar to change it to a line but after consulting someone else in my workplace it got fixed thanks guys