+ Reply to Thread
Results 1 to 4 of 4

Dynamic Chart

  1. #1
    Registered User
    Join Date
    05-30-2019
    Location
    Köln
    MS-Off Ver
    W10Pro
    Posts
    11

    Dynamic Chart

    Hi all,

    In the attached xls i have created a chart based on a table. We can see that in foto "M" there are no value entries, and in foto "1" values were added. Into the foto 2, with rows only partially completed values, chart is going on 0 line from where values end. I need the red line to stop where values end, not to go on zero line up to the end. I also hope that the whole chart will be better visible, as the dimensions would increase.Can anyone please help me with this issue?
    Thank you very much!

    Best regards,

    xls is in Protected View, without password.
    Attached Images Attached Images
    Attached Files Attached Files

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

    Re: Dynamic Chart

    for charts the data source needs to be #N/A rather than "" if you do not want the points plotted. You need to alter you IF formula to use NA() instead of ""

    Your layout of data is not best suited to charts, merged cells and non contiguous ranges.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-30-2019
    Location
    Köln
    MS-Off Ver
    W10Pro
    Posts
    11

    Re: Dynamic Chart

    Hi, from formula bar:
    " =SERIES("Ground";('002'!$E$72:$E$107;'002'!$R$73:$R$107);('002'!$K$72:$K$107;'002'!$X$73:$X$107);1) "
    " =SERIES("Bohrung";('002'!$E$72:$E$107;'002'!$R$73:$R$107);('002'!$I$72:$I$107;'002'!$V$73:$V$107);2) "
    and in cells i have:
    " =IF(G73="";"";(C73-C72)*SIN(ATAN(G73/100%))+I72) " - for serie 2
    " =IF(OR(I73="";M73="");"";(I73+M73)) " - for serie 1
    " =IF(I73="";"";E72+SQRT((C73-C72)^2-(I73-I72)^2)) " - for horizontal axis(Lange)
    even if i have merged cells and non-contiguous ranges, i made formulas to take only firs column in consideration, and all chart is working very well.

    Now, i wil try to figure out how i can alterate some formulas to receive #N/A error(i don't have vlookup function used for chart, only this return #N/A error), wich i hope(folowing your tipps) to resolve my needs.

    Thanks for help, i am working on it!

  4. #4
    Registered User
    Join Date
    05-30-2019
    Location
    Köln
    MS-Off Ver
    W10Pro
    Posts
    11

    Re: Dynamic Chart

    Solved! Thanks!

+ 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: 7
    Last Post: 05-08-2019, 05:24 AM
  2. [SOLVED] Dynamic Range/Dynamic Chart Using Cell Value for Reference and without CountA
    By kelseygueldalewis in forum Excel General
    Replies: 11
    Last Post: 09-11-2017, 04:52 PM
  3. [SOLVED] dynamic chart values formula with dynamic starting point
    By Kramxel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-24-2015, 03:30 AM
  4. Wants to Create Dynamic Chart basis on Dynamic Table
    By Nisha Dhawan in forum Excel General
    Replies: 6
    Last Post: 04-30-2015, 12:08 AM
  5. Replies: 1
    Last Post: 04-10-2015, 11:53 AM
  6. VBA - Updating Dynamic Line Chart & Inserting Dynamic Formula
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2014, 10:10 AM
  7. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 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