layout

I'm trying to figure out the best layout for this table (using Win 10 Excel 2016), but I'm not sure after having tried a bunch of different things, so if anyone has any recommendations, I'd be much obliged. See a couple quick examples I created below. Example two seems my best bet as I can...

Hi, So I have a graph with a legend on the RHS. If I go to design - select data and hen arrange he order of the legend to the order I want via the arrow buttons, it is not in sync with the actual legend (only one graph). If I go to the graph and click the filter button that appears (top right...

I have a PowerPoint presentation that has been created through VBA in Excel, to this presentation I have applied a custom template including various custom layouts. I have no issues referring to the specific slide in PowerPoint through Excel VBA, but when trying to change the layout to one of...

<a href=http://www.filedropper.com/lilayout><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >File Hosting Online...

I have a worksheet with over 3 months worth of data entry. My coworker claims she can't understand the layout. She wants me to change it from example 1 to example 2. Is there any easy way to do this without re-entering 3 months worth of work? Example 1 <tbody> WK# Date Accnt Name 1 7/9/15...

Hello all! Quick question about Pivot Tables and their layouts. I have data in a pivot arranged in rows with the Employee name, followed by the hour of day (a filter trick we had to use) then an activity. So the format looks like this Employee Name Hour of Day Activity...

Hello All! I'm in the process of creating a spreadsheet that monitors the hours worked for employees under 3 different managers...there are a number of things the sheet will report such as 'total weekly hours', 'total hours worked in one shift' etc. The spreadsheet needs to cover every week...

Lately I have been making macro's with the macrorecorder in excel and everything works fine except for the charting. Apperently the macrorecorder in 2007 is not able to create and adjust new shapes. Unfortunately I need to have a columnchart as some kind of summary at the end of my macro, but...

To all I am sure I have seen this in an on-line help but can't find it. My excel set-up (the template) has a few columns to fill. Some of this columns can only have specific values (selected from a drop down menu). The data is then used to create a number of "fixed" pivot tables Example of...

Trying to create a stacked bar chart with multiple series and am not sure how to lay out my data. Keep getting Series 1 that contains data from all three. Right now I have my data like follows <tbody> Control No Variance High Impact Low Impact GSA Additonal ATP PS-1 8 2 2 3 PS-2 4 1 2 0...

Hi All, I'm working on a bit of a mammoth task and I need to figure out what's the most organised way to display all the data on a master spreadsheet. I have about 8-10 spreadsheets that contain first names & surnames and the persons User ID for a specific location. Each spreadsheet has...

I have a table in Excel 2007 looking like <colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Identification Specification Budget Prognosis Acounting Dimension_1 Dimension_2 Name Category Description Function Creditor_ID...

Hi, I need to work with large amounts of data to get information from rows to columns. I'm pretty sure its with a pivot table. How do I do this? I was able to move the data to one single column in the pivot table "field settings" then "layout", however I need each item in its own column...

Hello, I'm trying to transpose some data I receive from a report into a format I require. The format I receive is as follows: Column Names as follows: Inspection No, RoleCode, OIN, InspectorName 340123, S5l1-2, 123123, Mr Smith 340123, QAR, 147147, Mr Jones 340123, SAFE, 159159, Mr Black...

I am new to Access and have taken a number of courses, but based on my research I am having a hard time envisioning how to set up a new database for my group. Specifically, I can't figure out how to organize the tables correctly. I'm hoping someone can help me. Thanks in advance. I need to...

Hi there, Just wondering if there's an easy way to turn a table of data formatted like this: Country, 1960, 1961, 1962, 1963 Angola:, 10, 12, 14, 16 Benin:, 20, 14, 12, 31 ... Into this: Angola, 1960, 10 Angola, 1961, 12 Angola, 1962, 14 Angola, 1963, 16 Benin, 1960, 20 Benin, 1961, 14...

Hello, new to the forums, thanks for taking the time to look over this. I'm looking to organize a set of data using either a pivot table or other summarizing/reporting method. Here is a breakdown of what I'm organizing: Department, Name, Audit Type, Week of Audit The only thing is that each...

:confused: Is it possible to change page layout to all pages of a workbook at once vs. changing one page at a time? I inherited a workbook, and would like to have all pages with the same margins, orientation, etc.

I have a very long but very narrow listing of data that I would like to print in a side by side layout. For example printing items 1-50 on left of page one and 51-100 on right of page one and then 101-150 on left of page two. Seems like it would be wasy I have simply not been able to locate...

Is it possible to export a access report to html with getting several pages for longer reports. If possible i would like to keep existing images and lay-out in this report. Is this possible using vba? G.