Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Nikki
 
Posts: n/a
Default Line and Column Graph

I have a graph that has six series. Each column has a line that goes with it.
Ex-
Pink bar and Pink Line
Blue Bar and Blue Line
Green Bar and Green Line

Now all the lines line up on the middle bar which happens to be pink. I
want each data point to line up with the correct color bar not with the
middle bar.
--
Thanks,
Nikki
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

What kind of bar chart do you have? Clustered, Stacked?

"Nikki" wrote in message
...
I have a graph that has six series. Each column has a line that goes with

it.
Ex-
Pink bar and Pink Line
Blue Bar and Blue Line
Green Bar and Green Line

Now all the lines line up on the middle bar which happens to be pink. I
want each data point to line up with the correct color bar not with the
middle bar.
--
Thanks,
Nikki



  #3   Report Post  
Nikki
 
Posts: n/a
Default

Clustered-I saw there was a link to a website that had the directions - Now I
am not sure about how to add the spacing to the graph.
http://www.peltiertech.com/Excel/Cha...olAndLine.html

"Barb Reinhardt" wrote:

What kind of bar chart do you have? Clustered, Stacked?

"Nikki" wrote in message
...
I have a graph that has six series. Each column has a line that goes with

it.
Ex-
Pink bar and Pink Line
Blue Bar and Blue Line
Green Bar and Green Line

Now all the lines line up on the middle bar which happens to be pink. I
want each data point to line up with the correct color bar not with the
middle bar.
--
Thanks,
Nikki




  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

Nikki -

The last approach, Line-Column Combination Chart with Sparse Data Range,
is probably easiest to get the spacing correct.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Nikki wrote:

Clustered-I saw there was a link to a website that had the directions - Now I
am not sure about how to add the spacing to the graph.
http://www.peltiertech.com/Excel/Cha...olAndLine.html

"Barb Reinhardt" wrote:


What kind of bar chart do you have? Clustered, Stacked?

"Nikki" wrote in message
...

I have a graph that has six series. Each column has a line that goes with


it.

Ex-
Pink bar and Pink Line
Blue Bar and Blue Line
Green Bar and Green Line

Now all the lines line up on the middle bar which happens to be pink. I
want each data point to line up with the correct color bar not with the
middle bar.
--
Thanks,
Nikki




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I combine a line and a percentage stacked column chart? Liza Charts and Charting in Excel 1 February 3rd 05 02:40 PM
Line Column Graphs Andy Charts and Charting in Excel 1 February 3rd 05 11:20 AM
Column Chart to Line Chart enquirer New Users to Excel 1 January 17th 05 10:55 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 02:09 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"