+ Reply to Thread
Results 1 to 2 of 2

Rotate dates in a Chart's Data Table

  1. #1
    Forum Contributor
    Join Date
    02-09-2011
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    161

    Rotate dates in a Chart's Data Table

    Hi,

    I have a chart with a Data Table displayed along the horizontal axis with dates and values.
    As the chart covers a few years and I am showing weekly dates the chart is unmanageably long.
    Is there a way to rotate the dates in the data table so that they are displayed vertically?


    Thanks very much

    Dave

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Rotate dates in a Chart's Data Table

    You do not have much control on how the data table looks, so no you can not rotate header.

    Usual approach is to use cells to build the data table outside of the chart itself.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-15-2017, 09:24 PM
  2. Rotate data labels in Donut chart in 18Oo
    By beneesetas14 in forum Excel General
    Replies: 6
    Last Post: 04-30-2015, 06:34 AM
  3. How to rotate a data Table in Excel 2010? (NOT TRANSPOSE)
    By jamonzonv in forum Excel General
    Replies: 1
    Last Post: 09-23-2013, 06:12 AM
  4. Rotate a chart
    By cj1958 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-04-2010, 10:30 PM
  5. Rotate excel data axis, not in chart format
    By jb2382 in forum Excel General
    Replies: 1
    Last Post: 03-22-2006, 07:50 PM
  6. Can I rotate data in Excel table (rows to columns, and vv)?
    By Marcus Ricci in forum Excel General
    Replies: 5
    Last Post: 01-19-2006, 08:00 PM
  7. [SOLVED] How do you rotate a table of excel data from horizontal to vertic.
    By DavidEllis_97062 in forum Excel General
    Replies: 2
    Last Post: 02-12-2005, 12:06 AM

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