• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart automation

SAN04

Member
I want to prepare chart for all module.

One chart i prepared for S01 and now the charts will be similar for all modules viz. S1, S2 & S3 with same formatting.

Now i dont want to change it manually by "select data" and change the selection as in this case the modules are only 3 but they could be 100 in some of the cases.

Please help!

Sheet attached for reference.

Thanks in advance.
 

Attachments

  • Graph.xlsx
    31.8 KB · Views: 6
SAN04
Could You continue with this?
Usage: Do selection
... and You can add 'as-many-modules-as-need'

Just noticed ...
that this seems to have 'some' kind of connection with Your previous thread.
... which has differences with this threads layouts and so on
... ... as well as that could be done with this thread too
 

Attachments

  • Graph.xlsb
    39.8 KB · Views: 3
Last edited:
Thanks Vletm...We can use selection but at same time i have to display all the charts in one Tab with S0, S1, S2 and S3 (Just like dashboard)
 
SAN04
Your: in this case the modules are only 3 but they could be 100 in some of the cases.
Your sample file should give image - what do You really would like to have?
 
Where does the data come from? If there can be 100s of these tabs you surely can't have typed that data in manually?!
I feel that there has to be a MUCH easier way of getting what you want.
Excel can probably handle the file(s) or database this data comes from more easily and more robustly than what you're doing at the moment.
 
SAN04
Your: in this case the modules are only 3 but they could be 100 in some of the cases.
Your sample file should give image - what do You really would like to have?
This way i need charts Vletm (Please see chart tab)
 

Attachments

  • Graph.xlsx
    46.1 KB · Views: 1
Where does the data come from? Contractor on weekly basis.
If there can be 100s of these tabs you surely can't have typed that data in manually?! It comes in PDF on weekly basis. I punch that data manually in tabs (date wise on weekly basis).
I feel that there has to be a MUCH easier way of getting what you want. I need to summarize that weekly data and make chart for all modules in one tab. (attached sheet for reference)
Excel can probably handle the file(s) or database this data comes from more easily and more robustly than what you're doing at the moment.
. Data comes in pdf

Please see reply in red.
 

Attachments

  • Graph.xlsx
    46.1 KB · Views: 1
You get your data into Excel in a horrible format, you change it into another horrible format then you want to make umpteen charts on a 'Dashboard' from that horrible format.
This is prehistoric data processing and I'm bowing out.
 
SAN04
I cleared some formulas ...
There is [ ReFresh ]-button to get valid data from those other sheets than Charts & Data.
Note: There are rules for those sheets layouts!
Seems You didn't read my writings ... but something like this.
You can refresh those charts one by one manually.
 

Attachments

  • Graph.xlsb
    62.9 KB · Views: 4
SAN04
I cleared some formulas ...
There is [ ReFresh ]-button to get valid data from those other sheets than Charts & Data.
Note: There are rules for those sheets layouts!
Seems You didn't read my writings ... but something like this.
You can refresh those charts one by one manually.
Thanks Vletm ......Please tell process to put filter and make these charts.
 
SAN04
Just remember ... after [ Refresh ] data You can delete those dd-mmm -sheets.
Those charts will refresh when activate charts-sheet.

Q > process to put filer ... where?
Q > make ... as written in code ... use my sample file then those would be ready.
Modified version.
 

Attachments

  • Graph.xlsb
    62.8 KB · Views: 6
SAN04
Just remember ... after [ Refresh ] data You can delete those dd-mmm -sheets.
Those charts will refresh when activate charts-sheet.

Q > process to put filer ... where?
Q > make ... as written in code ... use my sample file then those would be ready.
Modified version.
Q> Process to put choose button above Graph and Refresh in data.
Q>Where to write the formula?
 
SAN04
A> What choose button? .. there are validations, because You could have a lot of those modules. Refresh belongs to Data-sheet.
A> What formulas? There no need any formula.
 
This was the small file which i sent you with lesser requirements and 3 module (S0, S1 & S2)

Now i want to apply this to big database having nearly (11 modules)....can not share here as it is official.

Please tell the process to make similar graphs for 11 modules by using your techniques.

Means method to copy the chart making macros to other workbook with more modules.
 
SAN04
... You wanted one graph
... You wrote about 100 modules
... You wrote about 4 modules
... You wanted three graphs
... You asked ... filters
... You want ... nearly 11 modules
When You would like to answer any questions?
When do You start to reading my writings?
If I would ... write the process ... then that process would be a long long long writing.
There are still too many details which will effect - what to do that those would work with more graphs?
Life is not copy & paste
and same is with coding.
I could make this with 99 graphs,
after You have written Your exact needs.
 
SAN04
... You wanted one graph
... You wrote about 100 modules
... You wrote about 4 modules
... You wanted three graphs
... You asked ... filters
... You want ... nearly 11 modules
When You would like to answer any questions?
When do You start to reading my writings?
If I would ... write the process ... then that process would be a long long long writing.
There are still too many details which will effect - what to do that those would work with more graphs?
Life is not copy & paste
and same is with coding.
I could make this with 99 graphs,
after You have written Your exact needs.

Thanks VLETM

Please find attached detailed sheet. Attached sheet for reference & tried to put exact needs:

1) Data will come in "date" tab (input by me) - Please see 04-Apr tab - Info
2) Now data should be summarized in "Data" tab for all dates automatically once the another tab is inserted with name in "DD-MM" format (currently assume 11-Apr)
3) Now the Charts are required for all 12 Module and total of all module as in "Charts" tab. Charts for one module A1 shown in file.

It will be helpful if some easy way out so that if some requirements are changed i can also do some tweak accordingly.

Attached sheet for reference.
 

Attachments

  • SoL.xlsx
    69.1 KB · Views: 3
SAN04
Seems that You ...
... Have changed You ... totally!
Here is my version, based Your original ... dreams.
I should try to find out some words later.
Hint. Next time, use eg two-three seconds to think, before You'll ask someone something - what do You really would like to 'want'?
Question: What would be 'some easy way'? Do You know any?
 

Attachments

  • Graph.xlsb
    52 KB · Views: 5
Back
Top