linking only one part of the graph to an excel datasheet

0

Hi everybody.

If i have a ppt with a stacked column thinkcell graph (including several columns) and i want to have only one column of the whole graph to be feeded / linked to an excel data sheet ( this data sheet has first to be filtered, resultung in the needed data.), is that possible?

So at the end I have a presentation with several slides and on some slides only one column out of a whole graph will be changed. The goal is to only click 'refresh' instead of copying the whole thing from the excel over and over again...

Thanks

Theresa

Answer
Discuss

Answers

0

My initial thought is to do something like having 2 charts stacked on top of each other and play around with the formatting so that it looks like 1 chart.

Basically, you just create 2 totally separate charts and put one over the other one.

Here is one of our tutorials that covers this topic:

Combine Multiple Chart Types in Excel to Make Powerful Charts

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login