graph using merged cells shows ghost "0's"! Fill question also

kip.duff

New Member
Joined
Jul 6, 2011
Messages
2
Dear Forum::

Excel 2007 in Windows 7. I'm trying to put together a new schedule proposal to my managers. I have been trying for about 3 hours to do a couple of things with no success. Two questions:

1) I have created a row of merged cells showing number of workers present in each hour of the day. The value in the merged pair of cells is the sum of the time in the two thinner columns above the merged cell. When I try to use this value in a graph, the graph takes two numbers from the merged cell. One is the desired data displayed in the merged cell, and the other value displayed in the graph is a zero- apparently the graph is treating the merged cell as two separate cells: the first cell containing the displayed value, and the other cell containing a ghost 0. The graphs look like a big saw tooth, dipping to zero between each value. How can I get the graph to look only at the intended displayed value in the merged cell?

2) I want to put a light blue fill in the cells that represent the night time portion of the chart (24/7 full coverage schedule). The fill lays in front of the existing graphics, is opaque, and blocks vue of existing elements. I have not been able to "send to back". How can I do this?

Much thanks, Kip.................
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top