Sedang Disiapkan

Excel Job by LRicci

Are you available for another excel project?

This time I need data displayed to spec. I think this is easy, but it beyond my skills. I'm estimating it is just a one hour, maybe two hour job. Not much, but it's all I have.

I'm uploading a scan with notes.

Instructions:

change data points to be a bar reflecting both low and high from columns C and D.

Color code the data by values in column B (A B C are the major values, but several fit between, so use 5 values instead of 3 to cover them all)

Add a data range for columns E and F, same style. You'll need to muck with the axis to get these much smaller numbers to array similarly.

Once you have it set, adjust the axis to eliminate dead space and give the data some room to display.

Final deliverable: leave the chart on the same page/sheet as the data. I'll want to zoom in on the chart, but have the data on the same page for ready reference. My users will get confused if they have to flip between sheets. We don't have room for the names to appear, so they'll want the data handy.

Please let me know if you are interested!

Kemahiran: Excel

Lihat lebih lanjut: sheets add, hour change 2012, reflecting, flip chart, estimating, custom data display excel, excel array, project bar, code project scan, color code reference, excel custom, time sheets excel, range column chart excel, project chart, zoom bar, excel project easy, estimating excel, code page flip, estimating job, page flip code, chart project excel, need excel project, project time sheet excel, scan add excel, job change sheet

Tentang Majikan:
( 22 ulasan ) business, United States

ID Projek: #1557108

Dianugerahkan kepada:

ExcelContractor

Hired by the Employer

$35 USD dalam 3 hari
(2 Ulasan)
1.9