Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2021, 08:27 PM
alsheps alsheps is offline Question about Charts.. Windows 10 Question about Charts.. Office 2019
Novice
Question about Charts..
 
Join Date: Aug 2021
Posts: 2
alsheps is on a distinguished road
Default Question about Charts..

Hi,

I'm trying to build a chart that has 4 series in them, which is easy enough, except...

Series 1 and 2 are to be expressed as custered columns, and series 3 & 4 are being listed as lines with markers, using the markers only (or scatter if thats better)



The thing is, series 1 and 2 are showing side by side, which is great, that's what I want, but series 3 and 4 (the markers) are showing one on top of the other, and I want the markers to show inline with the columns. series 1 lining up with 3, and 2 with 4.

Is there a way to do this? I have been trying a lot of different ways and I can't figure ot out.. Help please???
Reply With Quote
  #2  
Old 08-11-2021, 09:04 PM
Guessed's Avatar
Guessed Guessed is offline Question about Charts.. Windows 10 Question about Charts.. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

As far as I know, you would need to create this as two different charts.
Chart 1: Contains Series 1 as column and Series 3 as line overlay
Chart 2: Contains Series 2 as column and Series 4 as line overlay

Then in Chart 2, make everything apart from the columns and line invisible and position it in front of the Chart 1 content with a slight offset so the columns appear beside the Chart 1 columns.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 08-11-2021, 09:17 PM
alsheps alsheps is offline Question about Charts.. Windows 10 Question about Charts.. Office 2019
Novice
Question about Charts..
 
Join Date: Aug 2021
Posts: 2
alsheps is on a distinguished road
Default

Ah bummer, so no way to have them in the one chart?
Reply With Quote
  #4  
Old 08-11-2021, 11:34 PM
Guessed's Avatar
Guessed Guessed is offline Question about Charts.. Windows 10 Question about Charts.. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It appears to me that you can't do it with overlay lines but perhaps you could do it with XY scatters as your overlay if you add more columns of data to give both the X and Y coordinates of the overlay info.

Alternatively, you might consider a different chart type to display the data. If it was me doing this, I would avoid the overlapping charts and try to do it with these two techniques.
This is the look for each column/line overlay: Overlap Graphs in Excel - Actual v Plan/Target - YouTube

And combine it with this methodology to get the second column and overlay sitting beside it Excel Column Chart | Replicating COVID-19 Overlapped Bar Chart - YouTube
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
charts

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
After updating linked excel charts in publisher, all charts are moved effinglife Publisher 0 05-23-2017 02:27 AM
Pie Charts EMS Excel 5 02-24-2017 04:25 PM
Question about Charts.. Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question rsrasc Word VBA 7 03-28-2014 12:28 PM
Charts mina-mi PowerPoint 0 05-08-2012 03:37 AM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft