Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charting of Merged Cells
I am trying to create identical charts from data that isn't formatted exactly
the same. In this particular case, I'm creating charts to show the number of defects in a given department for each month. One department may have two machines with the total for the two merged into a single cell. Another department may have 4 machines with the total merged into a single cell. When the charts are created, Excel is treating the merged cells as separate cells. For example, the chart for department with 4 machines will show Jan, blank, blank, blank, Feb, blank, blank, blank, etc... Any ideas on how to make the chart for the department with 4 machines to just show Jan, Feb, Mar, Apr, etc...? Thanks, Zack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Autofit row height work with merged cells | Excel Discussion (Misc queries) | |||
Merged cells | Excel Worksheet Functions | |||
How to sort merged cells | Excel Worksheet Functions | |||
Auto fit merged cells | Excel Discussion (Misc queries) | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |