+ Reply to Thread
Results 1 to 1 of 1

chart creation where the axis keep sub-dividing rather than show their names

  1. #1
    Forum Contributor
    Join Date
    11-11-2004
    MS-Off Ver
    pro + 2019
    Posts
    134

    chart creation where the axis keep sub-dividing rather than show their names

    I've got a table of a swimmer's times.

    While I'd love to have a dropdown that selects the event and populates the chart with THAT event--I am content for now just making 6 or so charts.

    I don't seem to have an affinity for the chart wizard, and I'd like to avoid getting any plug-ins for excel if that's possible. I've always found with a little effort, excel has everything I need.

    Issues to fix:

    1. I can't get the x-axis to just show the dates of each meet. 5/7, 5/14, etc. It keeps wanting to put "fractions" in between. In a perfect world Id like the x-axis to show the name of the meet AND the date.
    2. I'd like the data points to skip weeks where there was no event and not just interpolate the line

    3. the y-axis: I'd like the graph to be meaningful, so not making an arbitrary time range (making the plots a compressed) should be avoided. How can I make the y-axis for a particular event be from 0 seconds to maybe 5 seconds above the highest time for that row?
    Attached Files Attached Files
    Last edited by rcane; 05-29-2022 at 12:20 PM.

+ 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: 3
    Last Post: 01-27-2020, 12:46 PM
  2. Can't get axis labels to show up on my chart
    By dianaCatz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2019, 11:28 AM
  3. [SOLVED] Primary Axis & secondary Axis have high gap to show in chart
    By leakhna in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-05-2018, 02:19 AM
  4. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  5. Show Y Axis on both ends of a chart
    By mksnyder in forum Excel General
    Replies: 4
    Last Post: 01-22-2008, 06:35 PM
  6. [SOLVED] negative [h]:mm:ss does not show on the x axis of a chart
    By Devo Clubber in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-29-2006, 08:25 AM
  7. Chart with dynamic x-axis names
    By Jon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2005, 10:06 AM

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