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).
Best Answer
Insert data to Excel 2007 from ...
Open CSV file
open wizard part I
open wizard part II
open wizard part III
insert cell choice
refreash data options from CSV file
view CSV file in Far Manager
Set type of chart
Edit CSV file
Refreash Excel data
Edit CSV file
Refreash Excel data
Security data setting
It all. If need insert rotate table and graph picture).