How do I keep graph "data table" formats in separate excel workboo

S

Stacey D.

I have 1 master file that contains all the details to create various graphs.
I would like to have these graphs included in various other excel files.
When I copy the tab with the graph from the original workbook into a new
excel workbook, the "data table" that is shown with the graph loses its
format (ie dollars and percentage formats get lost). Is there a way to
retain the formats of the "data table" without having to copy and maintain
the source data in each of the new excel workbooks?

The goal is to have graphs in each of the new excel workbooks get updated
automatically. Any thoughts or suggestions would be greatly appreciated!

Stacey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I keep excel chart "data table" formats in several workbook 1
Create a chart from a table in word thats dynamic 0
Consolidation Table from Different Excel Tabs with Different Format 1
How do I keep formatting when creating a chart from a pivot? 2
Excel 2007 vs Excel 2003: How to keep charts stable? 0
Doughnut Chart linked with the slicer in the pivot table 0
Excel 2007 problem with graph format 0
Totals in the data table but not in the graph / chart 1

Top