+ Reply to Thread
Results 1 to 6 of 6

Reversing a chart horizontally

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    Bahamas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Reversing a chart horizontally

    I am using Excel to create a chart of knitted garments. Basically the cells are made into a square grid and filled in with symbols created from a font. At times I need to reverse the chart for the other side of the garment. I have looked everywhere but cannot solve this question. Can a chart be flipped horizontally?

    Thank you

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Reversing a chart horizontally

    Welcome to the forum.

    Double-click the x axis, tick Values in reverse order
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-17-2010
    Location
    Bahamas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Reversing a chart horizontally

    Thank you for your reply but I may have mislead you with the word chart. Attached is the grid with symbols that I need to flip horizontally.
    Attached Files Attached Files

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Reversing a chart horizontally

    Please Login or Register  to view this content.
    Adding Code to a Sheet module
    1. Copy the code from the post
    2. Right-click on the tab for the relevant sheet and select View Code. This opens the Visual Basic Editor (VBE) and shows the object module for the selected worksheet.
    3. Paste the code in the window
    4. Press Alt+Q to close the VBE and return to Excel

    Running a Macro
    1. Do Alt+F8 to open the macro dialog
    2. Select the macro name (Verso) from the dropdown list and press Run

  5. #5
    Registered User
    Join Date
    02-17-2010
    Location
    Bahamas
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Reversing a chart horizontally

    Thank you sooo much! Worked beautifully and as you can imagine saved me much time!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Reversing a chart horizontally

    You're welcome.

    Please send me a sweater ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1