Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I often find myself copying and pasting worksheets in order to show the same analysis for different sets of data. This includes graphs. It's irritating having to 'select data' for every data series, error bars, etc. for every data set.

Once I have created a graph for one worksheet, my choices are:

  • Copy the graph to another worksheet. Use 'select data' for every part
  • Copy the entire worksheet, then replace the data

I would much prefer to be able to see the XML (or whatever) representation behind the graph and be able to do a find-and-replace on the worksheet names/column names. The Excel interface gets in the way a lot and doesn't make it easy to change the graph repeatedly (particularly for error bars).

Is there some textual representation of objects like graphs I can edit? (I'd rather not mess around with extracting the xlsx file and editing the XML files in a text editor).

share|improve this question
    
You should be able to modify your charts using VBA. Also, if applicable, modify the chart source tables instead of the charts. –  mtone Feb 3 '13 at 18:44

1 Answer 1

Insert data to Excel 2007 from ...

link dato to excel

Open CSV file

Open CSV file

open wizard part I

open wizard part I

open wizard part II

open wizard part II

open wizard part III

open wizard part III

insert cell choice

insert cell choice

refreash data options from CSV file

refreash data options from  CSV file

view CSV file in Far Manager

view CSV file in Far Manager

Set type of chart

set type of chart

Edit CSV file

Edit CSV file

Refreash Excel data

Refreash Excel data

Edit CSV file

Edit CSV file

Refreash Excel data

Refreash Excel data

Security data setting

Security data setting

It all. If need insert rotate table and graph picture).

share|improve this answer
    
At this point it's probably simpler to feed your data from a database (such as sql server) rather than edit CSV files, for the same result. –  mtone Feb 3 '13 at 18:40
    
Yes, easier to use ms sql server. You can add screens to connect and work with a database and write stored procedures. I do not mind. –  STTR Feb 3 '13 at 18:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.