1. U

    Can I change the format of my data?

    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.
  2. M

    Auto-populating depending on two options

    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...
  3. I

    CHART: dates on Y-axis and time on X-axis

    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...
  4. B

    Cleaning up horizontal axis labels automatically

    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...
  5. S

    PowerBI align date ranges from multiple databases

    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...
  6. B

    I think this is simple, vertical information to horizontal..

    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...
  7. K

    Sumproduct or IndexMatch Function

    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...
  8. T


    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 =...
  9. T

    Converting horizontal data to vertical data with repeating data

    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...
  10. A

    Switching x-axes from horizontal secondary to primary

    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...
  11. Nelson78

    VBA: copy and paste in horizontal

    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...
  12. Jym396

    Chart Help-Add Horizontal Line

    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
  13. cnestg8r

    Secondary Horizontal Axis

    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...
  14. J

    Display range of numbers as horizontal lines

    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------------------...
  15. C

    Unable to set the .HorizontalAlignment property of the Range class error

    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...
  16. B

    Vertical and Horizontal Criteria Summation

    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...
  17. H

    how to paste data from horizontal into vertical in excel?

    I copied data from webpage that were presented in horizontal, and I want to paste them in Excel sheet in vertical. I tried (Transpose) but it did not work
  18. P

    Turn horizontal data to vertical

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to prepare a VBA code so that to run through row “2” and where find blank column, should turn the section’s data below of the previous one with one blank...
  19. S

    Changing horizontal data to vertical data

    I have twelve cells of vertical data in a worksheet which I would like to put into a different worksheet in a horizontal fashion with all the correct data and formulae attached within the same excel workbook. I have used paste options transpose but this didn't work.
  20. C

    Adding Vertical and Horizontal Scrollbars in a userform using Userform_Activate method

    Folks, I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only. Private Sub UserForm_Activate() With Me .ScrollBars = fmScrollBarsHorizontal .ScrollWidth = .InsideWidth * 1.5 End With End Sub The...

Some videos you may like

This Week's Hot Topics