Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Combine Charts from Multiple Tables?

Combine Charts from Multiple Tables?

Combine Charts from Multiple Tables?


  I have multiple tables, all basically providing the same metrics, other than the person(s) assigned.

  I would like to chart this some how, extracting data from these multiple tables.  How can this be done in a "clean format"?


RE: Combine Charts from Multiple Tables?

Combine the tables into a single table with a normalized structure.

RE: Combine Charts from Multiple Tables?

Hi MintJulep,

  This would be ideal, but I am extracting multiple data as follows:

I'm trying to track a dozen workers delivery statuses or Turn Around Time (TAT) on a week-to-week &/or month-to-month basis & determine if individuals are delivering "on-time", "late" or may be over-loaded with work.

My main criteria or parameters to track are:

Individuals - 12 - 15
Duration - Weekly &/or monthly
Task Deliverable status - "On-time", "Late" & perhaps, some others, but I'll keep it to these to begin with

Once defined, be able to chart it, which I should be able to do. This information will be extracted from a log sheet that I already created.

My issue is that I can define 2 parameters well, but struggling to get in the 3rd parameter into a "clean" table format & then be able to chart these results. Additionally, I would like to have all this defined simultaneously both in some type of table format & in a chart.

  In my data table, it's extracting data from my log worksheet, seeking:

Date Range Specified
TAT Status - On-Time, Late, etc.

Just curious if anyone out here was trying or did something similar & how they defined or created their spreadsheets & charts. Examples would be appreciative.

  I attached an example file in which I have a chart started on the "Weekly Metrics" worksheet.

  If you have other suggestions to condense these tables &/or charts, feel free to do so.


RE: Combine Charts from Multiple Tables?

If you do this to your supervisors, i'd hate to see how you treat your grunts.  Why not whip one of your people into manually compiling it for you?

But we uphold to help the capitalists too, so I ask: You are using a scatter plot right?  Scatter plot should readily accept blocks of data like this, and the format seems standardised enough.

RE: Combine Charts from Multiple Tables?

Hi KiwiMace,

  This is not intended to be a scatter plot, other than trying to capture the percentages.

  I have the table format that I want to collect the data.  Now, I'm just trying to figure out on how to chart this, preferably on run-type chart or a chart that I don't have to update every week.

Any suggestions anyone?

RE: Combine Charts from Multiple Tables?


REDesigner09, you need to do some research on pivot tables.  For data with multiple fields, pivot tables can make sense of it all.  Otherwise follow KiwiMace's suggestion to "whip one of your people into manually compiling it for you".

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close