How to Create Cross-Cell Bar in Excel

How to Create Cross-Cell Bar in Excel

Question:

I want to show the numbers as bar:

From column D, I want to show the days by bar, each column is a whole day.

Answer:

It’s impossible to show the bars cross different cells, but we can show the bar by merging the cells.
1. Make a copy of the data in column D.
2. Find the maximum and minimum number. The integer of minimum number is the minimum limit (0), and the integer of maximum number plus 1 is the maximum limit (33).
3. Select the data range (from the second row at least, the first row is header row, it’s D2:AK10), select Merge Across, merge the cells.
4. Select the data range, click Conditional Formatting, point to Data Bars, click More rules….
5. Choose Number behind Type, fill in the boxes with minimum and maximum limits in step 1.
6. Check Show bar only, choose a color you like, click OK.

You will see, a bar like below is created.