+ Reply to Thread
Results 1 to 4 of 4

Dynamic chart with break-off within data selection

  1. #1
    Registered User
    Join Date
    10-16-2013
    Location
    Nederland
    MS-Off Ver
    Excel 2003
    Posts
    38

    Dynamic chart with break-off within data selection

    Hello

    I'm creating a chart with the fluctuation of 3 different types of prices for multiple groups of items. Users should be able to add lines themselves and the chart should adapt to the amount of rows filled out.

    Price types B & C should be in columns, A should be in a line on top of these columns.

    Type A however should start on the left side of the item group with last month (9) and move to the right side of the item group this month (10). The line should not move from one item group to another but a new line should start for a new item group.

    Attached you will find the latest versions of me trying.
    Hope that I'm being clear and thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Dynamic chart with break-off within data selection

    You could look at these two tutorials, however I don't know that they will apply to the 2003 version.
    https://peltiertech.com/multiple-line-charts-category/
    Note that you may want to scroll down to the end of the article and look at the chart first.
    https://peltiertech.com/?s=dynamic+chart
    Scroll about 2/3 of the way down to the section "Charting a List or Table".
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    10-16-2013
    Location
    Nederland
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: Dynamic chart with break-off within data selection

    Thanks, that is looking very promising. Wil investigate and tell you the outcome

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Dynamic chart with break-off within data selection

    You're Welcome and thank you for the feedback. If the links should prove to resolve the issue, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. How to break dynamic links from table to chart in Excel 2010
    By GlennT in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2014, 05:12 PM
  2. Dynamic Chart Comparison Based on Drop-down Selection
    By Psionicrnd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2014, 11:25 AM
  3. [SOLVED] dynamic pie chart that shows 3 or 4 depending on selection
    By Sam Capricci in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-23-2013, 01:39 PM
  4. Dynamic Pie Chart Based on User Selection
    By mcollins789 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-03-2013, 06:17 PM
  5. Dynamic chart selection from userform listbox
    By kmsoni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2011, 03:22 PM
  6. Dynamic Chart Data Selection
    By NeoPhyx in forum Excel General
    Replies: 2
    Last Post: 06-11-2010, 12:21 PM
  7. TIP: Dynamic chart selection without code
    By Dermot in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-11-2006, 03:23 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