Two line graphics in one - to easy update

**HHvH** · 12-11-2015, 07:31 AM

Hi all

I hope I can explain what I'm looking for. I would like to have a dynamic line graphic - actually two in one, as if the two graphics were on top of each other.
I have made an example, in the below graphic I have placed two graphics on top of each other and if I want to ad a group f to 2014 and 2015, it is done automatic, and I dont have to change all the colours of the lines. Is it possible to do it in one chart since it looks more neet when it is not two plased on top of each other

Best
H

**Kaper** · 12-12-2015, 06:37 AM

I'm not sure if I understand what kind of "automatic" you mean. But let's try:
Make a chart of 2014, use a camera tool (see http://chandoo.org/wp/2008/12/02/exc...era-tool-help/ if you do not know this feature) and use the picture as background for your 2015 graph

**stasinek** · 12-12-2015, 03:31 PM

Hello, if you have installed the add-Power Query propose such a solution. Now you can add more details to your tabel. Refresh table data and PT with a sheet of "data and PT"

Two line graphics in one - to easy update

LinkBack

Thread Tools

Rate This Thread

Display

Two line graphics in one - to easy update

Re: Two line graphics in one - to easy update

Re: Two line graphics in one - to easy update

Thread Information

Users Browsing this Thread

Similar Threads

Easy way to update formulas when adding new spreadsheets?

Way to make this spreadsheet easy to update?

Combobox Value update different cells - easy

Macro to update cell (should be easy)

Graphics display - average line

make it easy to turn off the little paste option graphics

Really easy question - line break

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions