Hello everybody!
Although I follow the usual procedure for Chart insertion, the resulted chart is missing data.
Is something wrong with the file itself or...? It is very strange to me.
I attach the file in which I explain the problem in details.
Thank you
Last edited by Skakinen; 01-06-2014 at 05:16 PM.
Hi,
I think the 'Values' in the photo 2 chart should be '=charts!$J$5:$J$16', they were $I16.
The other chart has similar information for the Y axis.
Lewis
That's the problem!
I select the right cells but I get wrong chart.
I see said the blind carpenter as he picked up his hammer and saw.
Unfortunately, I can recreate your problem (Excel 2003), when creating the chart,
when I choose 4 or more months. When I choose only 3 months, then
everything works correctly.
Lewis
When you use all 12 rows excel thinks the first 11 are text.
You can change the formula to use NA() instead of ""
=IF(ISNUMBER(AVERAGE(DATA!D4:D34)),AVERAGE(DATA!D4:D34)*1,NA())
Or via the select data dialog, start by selecting only column D values. The alter the category range to use column C
After a few experiments I changed the formula to =IF(ISNUMBER(AVERAGE(DATA!D4:D34)),AVERAGE(DATA!D4:D34),0) and works fine.
Thanks for the answers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks