Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 12, 06:06 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 1
Default Plotting Line Graphs to Specific Bar Graphs

I am trying to create a double axis chart with 2 bar graphs and 2 line graphs, but I want the line graph to over lap with a specific set of bars and the other line graph to link to the other set of bars. If you were to look at the attached zip file, i would want the red dot to link (be centered on) the blue bar and the purple dot to link (be centered on) the green bar. Thanks!
Attached Files
File Type: zip 2 Bar 2 Line Chart.zip (11.3 KB, 156 views)

  #2   Report Post  
Old July 3rd 12, 08:40 PM
Banned
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Default

Quote:
Originally Posted by Elise Scoggins View Post
I am trying to create a double axis chart with 2 bar graphs and 2 line graphs, but I want the line graph to over lap with a specific set of bars and the other line graph to link to the other set of bars. If you were to look at the attached zip file, i would want the red dot to link (be centered on) the blue bar and the purple dot to link (be centered on) the green bar. Thanks!
Hi Elise,

you need to change the chart type for your scatter plots from line to XY scatter in order to accurately modify their X-position.
I quickly did that and attached your sample again. The correct X-position is dependant on the width of your columns.
In your sample X-pos 0.85 is the center of the blue column, 1 is the center between the blue and the green, 1.15 is the center of the green one...

If you need more chart samples, have a look over
here http://www.pimpmychart.com

Regards

Holger
Attached Files
File Type: zip 2 Bar 2 Line Chart (centered).zip (11.1 KB, 128 views)


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
Excel plotting graphs Qmm Charts and Charting in Excel 2 March 18th 08 04:39 PM
Help needed for plotting charts/graphs xxbenxx Excel Discussion (Misc queries) 0 January 27th 06 04:44 AM
Plotting Graphs Dharsh Excel Discussion (Misc queries) 2 May 24th 05 01:58 PM
plotting graphs johnd Charts and Charting in Excel 1 March 11th 05 12:52 AM
Plotting Graphs by Arrays d.i.barr[_6_] Excel Programming 0 November 22nd 04 04:31 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017