![]() |
|
#4
|
||||
|
||||
|
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 |
| Tags |
| charts |
|
|
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 |
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 |