+ Reply to Thread
Results 1 to 5 of 5

Charting formula results

  1. #1
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Charting formula results

    Hello people
    I'm trying to chart a range of cells that are populated by the result of formulas.
    Is there a setting or something special about how to go about it?
    If I put numbers in a range of empty cells, select them & create a chart, it works. If I do the same with the cells that have formulas in, it returns a blank chart even though the data range is correct.
    Any ideas please?
    Thanks
    Last edited by Philb1; 09-01-2011 at 07:43 AM. Reason: Solved

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Charting formula results

    Hello,

    never seen that before. Can you post a sample spreadsheet with the formulas you're using and the resulting chart?

    Are the results of the formulas numbers?

  3. #3
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Charting formula results

    Hello teylyn

    I attached the sheet. The blank chart is from G3:H16 & the chart that works is from P6:R16
    I want to be able to create a chart, after selecting the data, via a macro. I haven't got that far yet. It's stopped dead lol. I'll try to figure that bit out when this is sorted.
    Thanks
    Attached Files Attached Files

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

    Re: Charting formula results

    If you check the actual data being used by the chart you will see it thinks the first columns and rows are the series name.

    Name: ='Sheet2 (2)'!$G$16:$H$16
    Values: ='Sheet2 (2)'!$I$16
    XValues: ='Sheet2 (2)'!$I$3:$I$15

    Either manual adjust and add the series via the select data dialog.
    Or alter the formula to use NA() instead of "" as "" is treated as text and because the topleft of the range is text excel assumes they are labels.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Charting formula results

    Thanks Andy.. That was a bit of a performance to get a chart. I went the NA() way & conditional formatted the cells, so the text on "cell contains an error" is the same colour as the cell fill colour.
    Cheers
    Phil

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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