Chart values all appear in title, nothing on actual chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1410569%22%20slang%3D%22en-US%22%3EChart%20values%20all%20appear%20in%20title%2C%20nothing%20on%20actual%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410569%22%20slang%3D%22en-US%22%3E%3CDIV%3EI%20am%20trying%20to%20make%20a%20basic%20bar%20chart%20of%20values%20and%20dates.%3C%2FDIV%3E%3CUL%3E%3CLI%3EColumn%20A%20is%20dates.%3C%2FLI%3E%3CLI%3EColumn%20C%20is%20a%20list%20of%20plain%20numbers.%3C%2FLI%3E%3CLI%3EColumn%20B%20is%26nbsp%3B%3DIMSUB(C3%2CC2)%20--%26nbsp%3B%20the%20difference%20between%20numbers%2C%20cell%20by%20cell%2C%20in%20Column%20C.%3C%2FLI%3E%3C%2FUL%3E%3CDIV%3EI've%20attached%20a%20picture%20of%20what%20I%20get%20when%20I%20select%20A1thru%20B20%20--%26gt%3B%20Insert%20--%26gt%3B%202D%20Column.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAll%20of%20the%20values%20from%20B1-B20%20in%20the%20title%3C%2FDIV%3E%3CUL%3E%3CLI%3E%22%3CSPAN%3EDaily%20Reported%20Cases%20%23NUM!%2039%2051%2056%20112%20106%20130%20200%20243%20220%20240%20510%20507%20714%20840%20912%20754%201037%201032%201235%201260%22%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CDIV%3EA%20single%20date%20at%20the%20bottom%3C%2FDIV%3E%3CUL%3E%3CLI%3E%224%2F1%2F20%22%20which%20is%20the%20value%20of%20B20%3C%2FLI%3E%3C%2FUL%3E%3CDIV%3ENumbers%20along%20the%20side%3C%2FDIV%3E%3CUL%3E%3CLI%3E0.00%20at%20the%20bottom%2C%201.00%20at%20the%20top%3C%2FLI%3E%3C%2FUL%3E%3CP%3EWhat%20on%20earth%20is%20happening%3F%3F%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1410569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1410856%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20values%20all%20appear%20in%20title%2C%20nothing%20on%20actual%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410856%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676399%22%20target%3D%22_blank%22%3E%40maggiegrigs%3C%2FA%3E%26nbsp%3BUse%20normal%20subtraction%20of%20numbers%20to%20calculate%20the%20Daily%20Reported%20Cases.%20The%20IMSUB%20function%20is%20for%20calculating%20with%20imaginary%20numbers%2C%20and%20it%20returns%20a%20Text%2C%20not%20a%20real%20number.%20That's%20why%20you%20see%20no%20columns%20for%20the%20daily%20values%20in%20your%20chart.%3C%2FP%3E%3CP%3EHave%20a%20look%20at%20the%20attached%20workbook%20with%20a%20working%20example%20of%20what%20you%20probably%20want%20to%20achieve.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor
ADDITION (original post below): I used the =SERIES function to get a chart with the X and Y axis with the correct numbers, but I can't get any bars to show up. See "NEW" attached image.
 
ORIGINAL:
I am trying to make a basic bar chart of values and dates.
  • Column A is dates.
  • Column C is a list of plain numbers.
  • Column B is =IMSUB(C3,C2) --  the difference between numbers, cell by cell, in Column C.
I've attached a picture of what I get when I select A1thru B20 --> Insert --> 2D Column.
 
All of the values from B1-B20 in the title
  • "Daily Reported Cases #NUM! 39 51 56 112 106 130 200 243 220 240 510 507 714 840 912 754 1037 1032 1235 1260"
A single date at the bottom
  • "4/1/20" which is the value of B20
Numbers along the side
  • 0.00 at the bottom, 1.00 at the top

What on earth is happening??? 

1 Reply
Highlighted

@maggiegrigs Use normal subtraction of numbers to calculate the Daily Reported Cases. The IMSUB function is for calculating with imaginary numbers, and it returns a Text, not a real number. That's why you see no columns for the daily values in your chart.

Have a look at the attached workbook with a working example of what you probably want to achieve.