How to Create Cross-Cell Bar in Excel
来源:互联网 发布:google 高程提取软件 编辑:程序博客网 时间:2024/06/05 05:59
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.
0 0
- How to Create Cross-Cell Bar in Excel
- How to Find a Blank Cell in Excel Using Vba
- How to create an Excel sheet or chart in VC?
- How to create an Excel sheet or chart in VC?
- "HOW TO: Create a Smooth Progress Bar in Visual C# .NET"的学习笔记
- How to create function polymorphism in C
- How to Create Procedure in DB2
- How To Create Alternate Background In WPF?
- How to create Function/Procedure in Oracle?
- How to create a user in PostgreSQL
- How to create scheduler in liferay portlet
- How to Create QuickAction Dialog in Android
- How to: Create a Binding in Code
- How to create new module in npm
- How to create custom price in Magento?
- How To Create Database In MongoDB
- How to Create Mysite in SharePoint 2010
- How to create this array in Ruby?
- strptime的威力
- Opencv均值滤波-blur函数
- Opencv高斯滤波-GaussianBlur函数
- 多个按钮其中被按下按钮高亮显示
- Opencv中值滤波器-medianBlur函数
- How to Create Cross-Cell Bar in Excel
- Opencv双边滤波器-bilateralFilter函数
- Ember.js 入门指南——handlebars显示对象的键(未完待续)
- sox和lame音频处理器
- Opencv图像非线滤波-滚动条
- 安卓中Bitmap的处理
- 【剑指Offer】跳台阶
- Opencv图像线性滤波-滚动条
- android 状态栏一体化实现