+ Reply to Thread
Results 1 to 5 of 5

Help with gap in chart

  1. #1
    Registered User
    Join Date
    01-12-2014
    Location
    Poland
    MS-Off Ver
    2003, 2010
    Posts
    3

    Help with gap in chart

    Hello.
    I can fix my chart to look what like my proffesor want.
    I add .jpg to see what I have (chart on UP) and what I need to had (this chart on down, with big "GAP").

    I cant do the relationship between "Siła wyciskania" Y-axis and "Pozycja stempla" X-axis. When I change range of X-axis there only change numbers on X-axis, not the chart. To better discribe look at the picture which I add.
    Please help me to fix this chart to look like on .jpg, line of chart can start on Y-axis, but later after the gap.
    Last edited by bezczel90; 01-12-2014 at 03:38 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Help with gap in chart

    Hi bezczel :-P

    1) Use attachement rather than link to external server.

    2) I have not downloadded attachement. speedy.sh tries to install some add-ins to browser.
    Disgusting.
    But 99% you shall use scatter plot (wykres punktowy XY) not linear (wykres liniowy) and defining data for series remember to show both Y and X data.

    3) Just in case - see similar rules (may be even more explicit) at http://www.excelforum.pl/regulamin.htm - rule 1.2

  3. #3
    Registered User
    Join Date
    01-12-2014
    Location
    Poland
    MS-Off Ver
    2003, 2010
    Posts
    3

    Re: Help with gap in chart

    thnaks for help with attachments I dont saw that earlier, sorry for links

    Stop aluminium 2099.xlsx
    Bez*tytułu.jpg

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Help with gap in chart

    :-(

    Have you tried to use my 2nd suggestion? indeed it was the case.

    OK. As you are fresh forumer, so this time I did it for you. See attachemet (I also moved all data concerning "Prędkość wyciskania" - series 3 and 4 - to secondary axis.)

    Remember to mark thread as solved (Thread tools above your first post in the thread)
    and if you found my answers helpfull - use samll stars in lowerleft corner of my post(s) - "add reputation".

    Pozdrawiam,
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-12-2014
    Location
    Poland
    MS-Off Ver
    2003, 2010
    Posts
    3

    Re: Help with gap in chart

    ohhh sorry i forgot to write that works (scatter plot)
    But thanks for help and fixed my chart, I compare your chart and my and I do like u. Thanks a lot I dont think that my problem is only with bad chart pick.
    Thanks for suggestion for marking as Solved

+ 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: 5
    Last Post: 12-05-2012, 12:07 PM
  2. Replies: 1
    Last Post: 07-14-2012, 11:46 AM
  3. Replies: 5
    Last Post: 08-08-2011, 02:09 PM
  4. can we combine line chart and colum chart in one chart
    By reedzhou in forum Excel General
    Replies: 1
    Last Post: 06-20-2011, 10:03 PM
  5. Cannot Activate Chart Area in Chart. Chart Object Failed
    By ahperez@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2006, 09:45 PM

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