Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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