Charting weekday performance by the day

  • Thread starter Thread starter Brad1982
  • Start date Start date
B

Brad1982

I have the daily efficiency numbers for machines with a header on th
date they were ran

so for example I have 9/2/04 and machines with efficiency 85, 82, an
86

I would like to graph performance based upon the day of th
week(mon-fri)

My dates are b20:h20, while my machine effieciency numbers are b21:h21
b22:h22, etc..
 
I selected my test data range-- A20:H30 (machine id's in column A???).

Then hit the chart wizard icon.

I chose BarChart
On the next dialog (Data Range tab), I made sure I checked Rows in the "series
in" option.

It seemed to work ok for me.
 
You must log in or register to reply here.

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

Count the Number of Weekdays by Month 3
Average Function (include Blank Cells and Zeros) 17
Creating automated timesheets 2
Add a FIXED MONTH and DAY with the CURRENT YEAR 1
Elapsed date & time in terms of days, to the second 3
How do I calculate the number of weekdays between 2 dates :? 1
payroll weeks / varying first day and week of the year 2
how to Show dates as the day of the week? 2

Back
Top