Results 1 to 6 of 6

Making improvements to chart generator tool - Easily adding or removing data?

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    10

    Making improvements to chart generator tool - Easily adding or removing data?

    Hello!

    I am currently working on my first-ever project using Excel VBA. I am working to create a tool / template that allows my end-users to input data about two items, the item's features, and then show a variety of different cost-comparison charts based on these features.

    At the moment, I have a stacked column chart and a Waterfall chart.

    I am stuck because I would like to make the tool more easily editable. For example,
    - Easily adding new Feature columns for the two bar charts.
    - Easily adding new Feature columns for the Waterfall chart.

    I have attached the .xlsm that I am working from.

    I hope that someone will be able to help me make this template more "living", in the sense that new users can easily adapt it to the data that they need to input.

    Thanks for your help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding and removing series to a chart
    By behrensf84 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2014, 05:56 PM
  2. [SOLVED] Can the name of a series data for a chart be changed more easily?
    By billj in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-24-2013, 11:25 AM
  3. Need help removing all symbols from a random string generator...
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2013, 03:48 PM
  4. Adding/Removing Column to all sheets & making formulas work
    By gregal0711 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2012, 05:09 PM
  5. Excel 2007 : Moving chart data to worksheet easily
    By smudgepost in forum Excel General
    Replies: 1
    Last Post: 07-06-2010, 07:37 AM
  6. Replies: 10
    Last Post: 03-25-2009, 10:09 PM
  7. XY Chart Improvements For Scientific Data
    By Phil Preen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-15-2005, 12:05 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