+ Reply to Thread
Results 1 to 3 of 3

Axis troubles - Scatter chart for individual dates with monthly summary as bar chart

  1. #1
    Registered User
    Join Date
    03-02-2013
    Location
    Milky Way
    MS-Off Ver
    Excel 2007
    Posts
    3

    Axis troubles - Scatter chart for individual dates with monthly summary as bar chart

    Hello, all.

    I'm stuck.

    I have a bar chart with four separate data series broken down by monthly counts (currently 7 months, all along the X axis). That's all well and good.

    What I have been trying (CEASELESSLY, IT SEEMS) to do is add a secondary horizontal axis that would reflect individual dates within each month, so I could chart important events/occurrences as a scatter chart. Technically, I don't even need that secondary axis label to be visible. I'd just like my scatter points to show up in "roughly" the correct area over each month.

    I'm assuming this is doable, but since it's driving me absolutely batty, I'm thinking (hoping) maybe it's simpler than I'm making it.

    Any guidance/pointers?

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

    Re: Axis troubles - Scatter chart for individual dates with monthly summary as bar chart

    you don't provide an example so not sure if this is what you are wanting.
    Combination column and xy-scatter
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,406

    Re: Axis troubles - Scatter chart for individual dates with monthly summary as bar chart

    after http://www.excelforum.com/forum-rule...rum-rules.html :
    Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    Also -> nobody wants to generate sample data to try with.

    Moreover - once you post a workbook, we know what already have been done (here - bar chart) and can try to fit solution into already existing frames.
    Best Regards,

    Kaper

+ 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. 3D XY scatter chart (x,y,z axis)?
    By Lv27 in forum Excel General
    Replies: 3
    Last Post: 12-09-2012, 07:22 AM
  2. Replies: 3
    Last Post: 06-19-2012, 06:51 PM
  3. Scale on X & Y Axis of the scatter chart
    By chanyke in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-27-2006, 09:01 PM
  4. scatter chart x axis problem
    By Suzan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-03-2005, 08:05 AM
  5. Scatter Chart Axis as text C#
    By Pablo Villalobos via OfficeKB.com in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-18-2005, 07:06 PM

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