Empty cells in excel

How to get that blank cells are not perceived as zeros?

It's for my other question in thread "Table and chart".
I think that I could mark larger area but at the moment blank cells are perceived as zeros and damage my chart.

But maybe you can tell me how to manage with that blank cells?

Originally Posted by Marcol

If your chart data is in A1 down
In say C1 enter this CSE array formula, confirm with Ctrl+Shift+Enter before dragging down

Formula:

Please Login or Register  to view this content.

This will remove any blanks from the list dynamically, refer your chart to this new list.

My data is in A1:AL193. Forward data will be written in columns AN, AO, AP... At the moment there are blank cells but I have to get that if I write data then data automatically will be represent in the chart.
I am thinking now where and how I have to use that formula.

Originally Posted by Marcol

For some reason I can't remove the attachment in post #6

Here's the workbook with a dynamic chart added.

Enter/Delete some values in Column A to see the chart working

Thanks.

Up up up up

You will need to post a sample of your workbook, explaining what you are trying to do.

There are to many possibilities from the description you have offered so far.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Here is a very simple and unreal example of my exercise.

So I have to get that if I write more data 05.08.2013, 12.08.2013, 19.08.2013 ... then charts will be supplemented automatically.

up up up up

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Please don't bump your post until at least a day has passed.
Bumping twice in an hour and a half is not a good idea, it just clutters the thread.
Remember we are all unpaid volunteers on this forum.

From the forum rules

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

Thank you for info.

Does the Sample I provided in post #17 work as you need?

It works for me as I see your question.

Exactly what doesn't work?

I supplemented the table with new row "Bags" and write formula exactly like yours only instead word "Books" I wrote "Bags" and get the same error message.

I don't understand. I can't see mistake.

Thank you very much!

Now I must try this on real data. I'll hope it works!

If I have hided rows and columns could it be a problem? Because in my real workbook I receive the same error message.
I defined all names, now I try to edit horizontal labels in the chart but I can't.

It coluld well be the problem!
Depends on what you have in these hidden rows/columns.

If this is to progress any further you would be better providing a sample of your actual workbook showing what is hidden.
The structure of a workbook is always a major part of any solution.

From what I have seen so far there is no sensitive data like peoples' personal details, if there is just disguise the data.

I am closer to result now. Only with some data it doesn't work. And I think I see a regularity what could be a reason of it. But at the moment I don't know how to manage with it.

I will not post my workbook here.

It look's like excel take some hide rows..

There is no blank cells in your example file!

In one hided column I have position codes like 1.1.1., 1.2.3. ... in other some between - results (dynamics between previous and next). And for some positions excel have take these positions codes, for other not.

Originally Posted by Rambo4711

There is no blank cells in your example file!

Should it be there?

I post a upgraded file with my example. There are hide row and columns like in my workbook. See sheet "Now".
Unfortunately position codes aren't added to series names there. With file Example. xlsx all is ok but with my file not.

I edited legend and achieved that position codes don't appear in series names. But previously mentioned problem still exists. For some series excel doesn't accept the formula.

Why all the hidden columns?

What is the purpose of these "Dynamics" Columns?

Are they the "Empty cells" you are referring to in your thread title?

These hidden columns are needed. But it don't interfere to make a chart, it interfere to make dynamic chart.
It's not important what hidden columns mean.
About thread title - I had 2 threads about my problem which was quite related but DIY recommended me to continue discussion here. Should I correct the title?

Problem is solved! Thank you all for help.