+ Reply to Thread
Results 1 to 5 of 5

Scatter chart: formulaic rather than based on a full table, is it possible?

  1. #1
    Registered User
    Join Date
    01-24-2020
    Location
    Just behind that tree
    MS-Off Ver
    2013
    Posts
    8

    Question Scatter chart: formulaic rather than based on a full table, is it possible?

    Hello, I am having to plot many scatter charts of activity against log time, which is OK. In the interest of saving space, I was wondering whether it would be possible if instead of making a table with all the data points, I could find a form in which I can plug in the formula I would use for the table. If not, I have to do something else in order to keep the data neat.
    Thanks.
    Admittedly, I did not go back far in this forum's history to get an answer, so my apologies if you answered this more than about eightteen months ago.
    Last edited by QuieT; 04-19-2020 at 02:14 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,962

    Re: Scatter chart: formulaic rather than based on a full table, is it possible?

    Administrative Note:

    Hi and welcome
    although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile to something more precise then "Just behind that tree" ( country will suffice, no need to be more precise).
    Thank you for helping us to help you

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,347

    Re: Scatter chart: formulaic rather than based on a full table, is it possible?

    Short but useless answer -- yes this is possible. Question for you -- why?

    Spreadsheets and their chart engines are designed to work with cells and ranges in the sheet(s). By far, the easiest way to graph an equation in a spreadsheet chart is to enter/compute the desired values in a block of cells in the spreadsheet and then build the chart from those cells. An Excel sheet has 1E6 rows and 16E3 columns -- and you can have as many sheets in your workbook as you have memory -- I am not sure what reasons one would have for "saving space in a spreadsheet." If it is a matter of not wanting to look at the data, rows and columns and sheets can be hidden so that you don't have to look at them, if desired.

    If you decide that you really don't want to use cells for your chart data, there's a technique out there:
    https://jkp-ads.com/Articles/ChartAnEquation00.htm
    An add-in that manages the process for you: http://tushar-mehta.com/excel/softwa...ger/index.html

    At this point, I would say that it is about understanding why you want to avoid using cells to contain the chart data, and then balance that against the added difficulty of these other techniques. After doing the "cost/benefit analysis", decide which approach you would prefer to use.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    01-24-2020
    Location
    Just behind that tree
    MS-Off Ver
    2013
    Posts
    8

    Re: Scatter chart: formulaic rather than based on a full table, is it possible?

    Those are some good considerations. Thanks for your thorough reply.

  5. #5
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,962

    Re: Scatter chart: formulaic rather than based on a full table, is it possible?

    Please read post #2. 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. Scatter chart with colors and shapes based off of values
    By dbrownla in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 05-01-2020, 08:21 AM
  2. Scatter chart with pivot table(4 areas)
    By FOXL in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-26-2019, 11:31 AM
  3. Scatter Chart based on a Client List with 2 variables
    By rissen1k in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-18-2016, 05:02 PM
  4. [SOLVED] Four quadrant scatter chart with defined X & Y axis based on averages
    By HeyInKy in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-21-2013, 08:55 AM
  5. How to show full totals in Pivot chart and table when you filter on one customer?
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 06:30 PM
  6. Replies: 1
    Last Post: 03-26-2012, 02:52 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