horizontal

Situation - there is a tally sheet where an employee tallies things that are missing based on States and Trucks run in a state. Each State "owns" a cell in the Sheet. If the Full State is missing, the employee types the State abbreviation in that State's cell. If a partial number is missing...

I am using excel 2016 for mac, and am trying to use the "horizontal (category) axis labels. in charts" But I can't seem to enter any thing into the box for this. Ultimately I want to be able to put data labels that are not the numeric x and y axis values, but cannot find a way to do that...

Why is my Excel Sheet showing nos instead alphabets on Horizontal bar ? https://ibb.co/emPKg9 Is there a fix for this ?

I have a chart with the horizontal axis rotated 270 degrees. I need to have the chart adjust as I make changes via VBA. This is what is recorded, but I don't know the exact height. How can this be modified to allow the horizontal axis is be completely visible and not scrunched up? Sub...

I have excel data vertical. However, the files I am getting to upload has the data horizontally. Is there a quick and fast way of changing the format to horizontal? Using Excel to transpose it, will take a long time.

Hi All I cannot see how to work this out, but I suspect it is very straightforward. I have a table as shown. <tbody> 1 2 3 4 5 6 7 1 A A A A B B B 2 A A A B B B B 3 A A B B B B C 4 A B C D E F G 5 B C D E F G H 6 C D E F G H H </tbody> On another WS - In cell B2 I will type a...

I am trying to figure out how to build a schedule chart with the dates on the vertical axis and times on the horizontal axis, and then use error bars for horizontal duration... The dates ae irregular and the on t horizontal axis is from 6 AM to 6 PM. I have worked with some charts I found on...

Hello, I need to clean this chart up so it only shows each month/year on the horizontal axis one time. The data range I am using as the horizontal axis labels is W14:DUR14. Each cell in this row has the Month/Year in sequential order, but lots of duplicates. The line data in the chart is on row...

Good morning, I have 3 databases in PowerBI Dekstop where I select for example the date range of Q2. Weird enough the data that is shown (in a horizontal bar chart) isn't aligned very well. The charts all start in April but the nexts months aren't aligned right above each other. I hope you...

Hello, from the image located below I would like to convert all of the vertical information into horizontal information. I know that you can use transpose but I have a problem here. I need this to be formula based to some degree. In other words, the horizontal information at the bottom, the...

Attached is an example file. I have about 100 tables of data I need to sumproduct. All are formatted the same but in the same vertical formation as shown in the sheet. I have been cutting and pasting, making them horizontal, but it is tedious to do for each month. Does anyone know of a way to...

I am trying to manipulate the horizontal page breaks in an Excel 2007 spreadsheet through VBA. The line of code I am using is: For a = 1 To sheetcount - 1 ThisWorkbook.Worksheets("Continuation Sheet " & Trim(Str(k + 1))).Range(sheetrange).rows(a * 44).EntireRow.PageBreak =...

I currently have a report of 8000 plus employees who have 12 rows of data each. each row of data has 3 columns that are represented for each month of the year. This is how my current reporting feature creates the report. the software I need to upload this data into is in the format below this...

Hello! I have a chart with 4 axes (i.e. horizontal primary, horizontal secondary, vertical primary and vertical secondary). I'm using Excel 2016 and need to switch the horizontal secondary axis at the top (date) with the horizontal primary axis at the bottom (number). Unfortunately, I...

Hello everybody. I'm struggling with a database in which some data (in the example, names of cities) could be repeated a lot of times. I need to report in another sheet the data, and then report in horizontal the related datas. See what I mean in the image https://imgur.com/a/HMMWHae I have...

I have a line chart with Dates on the X Axis (Jan 1-Dec 31)...and Hours on the Y Axis (0-12). I would just like to add a horizontal line (Series?) at 8 hours. Thanks, Jim

Jon Peltier makes a masterful presentation for ALL things related to excel charts. Thank you! Most recently I have followed his diversified methods of adding horizontal lines for average or n-sigma ranges. I am using excel 2016. After I get to the paste special step, I can see the series has...

Hi, I have a list of children names in A1:A20, and their heights in B1:B20 - 0.8, 1.24, 1.3, 1.47, 1.56 etc.. I would like to create a chart (or other visual option) that will draw horizontal lines on Y axes to represent the heights proportionally: 1.56------------------...

Unable to set the .HorizontalAlignment property of the Range class error I am encountering this error trying to set HorizontalAlignment in a VB.NET application. I have looked through many articles with solutions on how to resolve this error. I have tried setting this property in a variety...

Hello All, I need some help with the following: I have a list of codes in column A in which some are repeated. Then I have specific codings across the top horizontally that are individual, but will not always be in the same order. I need to be able to pull the sum by matching both. I'll...