Excel表格技巧:表格如何插入折线迷你图?

本教程适用版本:WPS 365 点击免费使用

表格图表过多,对比复杂,不利于我们的观察;WPS新推出的“迷你图”功能可以在一个单元格中创建一个小型的图表,从而更清晰的发现某一组数据的变化趋势。

若是大家遇到「迷你图表」是置灰状态,可能是因为版本过低,或者当前表格为XLS格式。可以将表格另存为XLSX格式后,重新打开表格,再使用「迷你图表」相关功能。

▪以此表格为例,鼠标定位于我们要插入折线迷你图的位置。

例如,我们将折线迷你图插入到 H2单元格中,单击选择这个单元格。

接着依次点击「插入」选项卡-「折线迷你图」,然后点击一下插入「折线迷你图」。

>免费升级到企业版,赠超大存储空间

▪在弹出的「创建迷你图」,我们需要选择折线迷你图的数据范围。

以输入一月到六月的数据为例,我们用鼠标选中B2到G2单元格。

这时我们看到折线迷你图的数据范围自动添加为B2:G2。

当然,我们也可以直接在数据范围中填写“B2:G2”,来确定数据范围。

>免费升级到企业版,赠超大存储空间

▪这时我们看到系统默认的位置范围就是我们刚才定位的单元格$H$2。

如果我们要修改位置范围,可以直接用鼠标点击我们需要的单元格,然后单击「确定」。

这样一个迷你的折线图就插入完成了,利用这个小的折线图,我们就能清晰的判断这组数据的变化情况。

>免费升级到企业版,赠超大存储空间

▪对于不需要的折线迷你图,鼠标右键单元格或者区域。

依次点击「清除内容」-「全部」就可以了,在这里我们要注意的是,折线迷你图只能插入到一个单元格之中。

当我们试图使用多个单元格时就会造成位置引用或者数据区无效的错误。

 

Keyword: 海外移民

Bloody Mary Blueberry Raspberry Nic Salt

BLOODY MARY BLUEBERRY RASPBERRY NIC SALT E-LIQUID

Bloody Mary Blueberry Raspberry delightfully pairs juicy, sweetly tart raspberries with vibrant and bright bursts of ripe blueberries, making for a berrylicious flavour to add to your vaping palate.
Explore other Bloody Mary Nic Salt e-liquids in their amazing blend that recreates all the enticing flavours with one of the most iconic single-use vape kits, Bloody Mary BM600. 

Specifications

  • Flavours: Blueberry, Raspberry
  • Nicotine Type: Nicotine Salt
  • Bottle Size: 10ml
  • Nicotine Strength: 10mg & 20mg
  • VG/PG Ratio: 50/50
  • Vaping Style: MTL
  • Easy Fill Nozzle
  • Childproof Cap

Bloody Mary Nic Salts come conveniently packaged in 10ml bottles, providing vapers with a budget-friendly, refillable nic salt e-liquid option that recreates the flavour-packed experience of disposable vapes.

With 10mg and 20mg nicotine salt strengths available, you can quickly satisfy your cravings. Using nicotine salts provides a smoother throat hit, enhancing your overall vaping experience.

Bloody Mary is one of the industry-leading vape manufacturers, world-renowned for their extensive range of 52 flavour combinations that are all available within their BM600 range of disposable vape kits. 

Having perfected the flavours within their range, Bloody Mary has now turned their attention, skill and expertise into creating 25 amazing flavoured nic salt e-liquids for the refillable sector, aiming at being a cost-effective nic salt option and, importantly, reducing the impact on the environment by lessening waste produced from throw-away single-use devices.

Expertly balanced in a 50/50 PG/VG blend, Blood Mary Nic Salts e-liquids are best used with Vape Starter Kits and Pod Vape Kits.

Are you new and trying out vaping for the first time? You should check out our beginners’ guide, where we simplify vaping to its fundamentals and explain the benefits of switching to your first vape kit.

Keyword: adhesive tape

Bloody Mary Blueberry B-Gum Nic Salt

BLOODY MARY BLUEBERRY B-GUM NIC SALT E-LIQUID

Bloody Mary Blueberry B-Gum is a fruity and tarty blend of blueberries and sticky bubblegum, oozing with an intensely sweet flavour.
Explore other Bloody Mary Nic Salt e-liquids in their amazing blend that recreates all the enticing flavours with one of the most iconic single-use vape kits, Bloody Mary BM600. 

Specifications

  • Flavours: Blueberry, Bubblegum
  • Nicotine Type: Nicotine Salt
  • Bottle Size: 10ml
  • Nicotine Strength: 10mg & 20mg
  • VG/PG Ratio: 50/50
  • Vaping Style: MTL
  • Easy Fill Nozzle
  • Childproof Cap

Bloody Mary Nic Salts come conveniently packaged in 10ml bottles, providing vapers with a budget-friendly, refillable nic salt e-liquid option that recreates the flavour-packed experience of disposable vapes.

With 10mg and 20mg nicotine salt strengths available, you can quickly satisfy your cravings. Using nicotine salts provides a smoother throat hit, enhancing your overall vaping experience.

Bloody Mary is one of the industry-leading vape manufacturers, world-renowned for their extensive range of 52 flavour combinations that are all available within their BM600 range of disposable vape kits. 

Having perfected the flavours within their range, Bloody Mary has now turned their attention, skill and expertise into creating 25 amazing flavoured nic salt e-liquids for the refillable sector, aiming at being a cost-effective nic salt option and, importantly, reducing the impact on the environment by lessening waste produced from throw-away single-use devices.

Expertly balanced in a 50/50 PG/VG blend, Blood Mary Nic Salts e-liquids are best used with Vape Starter Kits and Pod Vape Kits.

Are you new and trying out vaping for the first time? You should check out our beginners’ guide, where we simplify vaping to its fundamentals and explain the benefits of switching to your first vape kit.

DOES GEOTEXTILE STOP WEEDS?

Does Geotextile Stop Weeds?

Does Geotextile Stop Weeds?

Geotextiles are versatile materials used in various construction, landscaping, and environmental applications. They are often employed for purposes like soil stabilization, drainage, and erosion control. But one of their lesser-known yet highly practical uses is in weed prevention. If youre struggling to maintain a weed-free garden, walkway, or landscaping project, you might wonder: can geotextiles effectively stop weeds? The short answer is yes, but theres more to it.


How Do Geotextiles Prevent Weeds?

Geotextiles act as a physical barrier between the soil and the surface above, preventing sunlight from reaching the soil. Since weeds require sunlight to grow and thrive, this layer effectively blocks their growth. Heres how they work:

1. Blocking Sunlight:

By covering the soil, geotextiles eliminate the sunlight that weeds need for photosynthesis. Without light, weeds cannot germinate or grow.

2. Soil Separation:

Geotextiles also create a separation layer that prevents weed roots from penetrating upward. This is especially useful for invasive weed species with aggressive root systems.

3. Water Permeability:

Unlike plastic sheeting, geotextiles are water-permeable, allowing air and water to pass through while keeping weeds at bay. This ensures your plants and soil stay healthy.

Advantages of Using Geotextiles for Weed Control

1. Durable and Long-Lasting

Geotextiles are made from synthetic materials like polypropylene or polyester, designed to withstand outdoor conditions. Unlike organic mulch or chemical weed barriers that degrade over time, geotextiles provide long-term protection.

2. Environmentally Friendly

Unlike chemical herbicides, geotextiles offer a non-toxic solution to weed control. They prevent weeds naturally, without harming surrounding plants or soil organisms.

3. Low Maintenance

Once installed, geotextiles require minimal upkeep. Theres no need for repeated application, as you might experience with herbicides or organic mulch.

4. Versatile Applications

Geotextiles can be used in various settings, including:

Garden beds

Walkways

Driveways

Retaining walls

Landscaping projects

 

Whether youre a homeowner or working on a large-scale commercial project, partnering with a reliable geotextile manufacturer ensures you get the right material for your specific application.

Types of Geotextiles for Weed Prevention

1. Woven Geotextiles

Woven geotextiles are made by weaving synthetic fibers together, creating a strong and durable material. They are ideal for areas with heavy traffic, such as walkways or driveways, where soil compaction might be an issue.

2. Non-Woven Geotextiles

Non-woven geotextiles are made by bonding fibers together using heat or chemicals. They are softer and more flexible than woven types, making them perfect for garden beds and landscaping. Non-woven geotextiles are also excellent for drainage, as they allow water to pass through while blocking weeds.

3. Perforated Geotextiles

Perforated geotextiles offer additional drainage capabilities, making them ideal for areas prone to waterlogging. They combine weed prevention with effective water management.

 

Choosing the right type of geotextile depends on your projects specific needs. Consulting a trusted geotextile manufacturer can help you identify the best option for your situation.

How to Install Geotextiles for Weed Control

Proper installation is crucial for maximizing the effectiveness of geotextiles. Follow these steps for best results:

1. Prepare the Area  

Remove existing weeds, rocks, and debris from the installation site. Level the soil to create a smooth base for the geotextile.

2. Lay the Geotextile  

Unroll the geotextile over the prepared area. Ensure it covers the entire space, with overlaps of at least 12 inches where multiple sheets are used.

3. Secure the Edges  

Use garden staples or heavy weights to secure the geotextile in place. This prevents it from shifting during use.

4. Add a Covering Layer  

Cover the geotextile with a layer of mulch, gravel, or soil. This not only enhances aesthetics but also provides additional UV protection for the geotextile.

5. Maintain as Needed  

Check periodically to ensure the geotextile remains intact and replace coverings if they begin to degrade.

Where to Source Geotextiles

For effective weed prevention, its essential to use high-quality materials. Heres why sourcing from reputable suppliers matters:

1. Reliable Quality

A trusted geotextile manufacturer ensures their products meet industry standards for strength, durability, and performance. This guarantees the geotextile will perform effectively over time.

2. Cost-Effective Options

If youre working on a large-scale project, consider purchasing wholesale cheap geotextile to reduce costs without compromising quality. Bulk orders often come with significant discounts, making them ideal for landscaping businesses or commercial developments.

3. Technical Support

Suppliers with a strong reputation provide guidance on selecting the right geotextile type and proper installation techniques, ensuring project success.

 

Birla Carbon Plants in Brazil, Hungary, and Egypt secure ISCC PLUS Certification

Birla Carbon, a manufacturer and supplier of carbon-based solutions announces that four more of its plants – Cubatão and Camaçari in Brazil, Tiszaújváros in Hungary, and Alexandria in Egypt, have secured the ISCC PLUS certification.

Speaking on this recognition, John Loudermilk, President and Chief Executive Officer, said, “We are delighted to announce that our plants in Brazil, Hungary, and Egypt have achieved ISCC PLUS certification, representing a significant milestone in our sustainability journey.”

Earlier this year, the company got the ISCC PLUS certification for its facilities located in the USA, South Korea, India, and Italy. The certification process for the rest of its plants is currently underway and is slated for completion through the remainder of CY 2024. Birla Carbon’s commitment towards realizing net zero carbon emissions by 2050.

Keyword: Manufacturing

Biogenic silver nanoparticle coating for antimicrobial and antioxidant properties on polyethylene film

Using banana peel extract, an eco-friendly silver nanoparticle coating with antibacterial and antioxidant properties was developed for polyethylene packaging.

A new study in the demonstrates the biosynthesis of silver nanoparticles using banana peel extract as a reducing agent, subsequently applied to low-density polyethylene (LDPE) film. Characterized via scanning electron microscopy and X-ray diffraction, these biogenic silver nanoparticles were then coated onto LDPE films through a dip-coating process.


Reading tip: Silicon and Nanotechnology for Coatings

Dive into the world of advanced coatings with “Silicon and Nanotechnology for Coatings”. This comprehensive guide explores the intersection of nanotechnology and silicone chemistry, offering insights into enhancing coating performance through innovative materials. Learn about cutting-edge applications and future trends that are shaping the coatings industry.


The coated films exhibited significant antibacterial activity against both Gram-positive and Gram-negative bacteria and showed antioxidant properties in free radical scavenging tests. These silver nanoparticle coatings hold promise for sustainable packaging applications with enhanced protective functionalities.

Source: Journal of Coatings Technology and Research, Volume 21, pages 1409–1420, (2024)

Keyword: factory

Excel表格技巧:智能工具箱 批量删除

本教程适用版本:WPS 365 点击免费使用

WPS表格的「智能工具箱」包含60项高效小功能,帮助你高效办公,轻松工作不加班。

首先单击「会员专享」选项卡-「智能工具箱」按钮,开启「智能工具箱」功能选项卡。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

 

■ 删除空格

表格中出现空格或空白字符该如何删除?

空格是指单元格内的字符间存在空格,此时若想批量删除可以利用「智能工具箱」中的「删除空格」功能。

以此表格为例,在表格中有许多不同的单元格空格,应该如何批量删除呢?

首先框选整个工作表,单击上方「智能工具箱」选择「删除」按钮下拉单击「删除空格」按钮。

选择需要删除哪一种类的空白单元格,删除的同时会在弹窗中自动标注出工作表中的空白单元格。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

 

■ 删除超链接

在文件中插入的超链接,直接点击单元格删除超链接有时候会自动跳转至网页,如何快速删除超链接呢?

首先框选需要删除删除超链接的单元格,单击「删除」按钮选择「删除超链接」。

在弹框中单击「确定」按钮此时单元格中的超链接就删除了。

 

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

 

■ 清空0值

库存中有0库存的商品一个个单元格删除很麻烦,智能工具箱的删除功能可以帮你快速删除。

单击「删除」按钮选择「清空0值」,弹窗会自动提示已经几个0值单击「确定」按钮即可。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

 

智能工具箱中的删除功能中还有超多功能,大家快去试试吧。

Keyword: 移民美国

Excel表格技巧:巧用SMALL函数 查找数据集的最小值

本教程适用版本:WPS 365 点击免费使用

SMALL的中文含义是“小”,它的函数使用也与“小”有关。

运用这个函数,我们能够查找到一组数据中的最小值。以这个表格为例,我们来实际操作看看。

■ 选中B2单元格,点击插入函数,找到SMALL函数,点击确定。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

■ 在此,我们需要输入两个数值:

数组指我们要查找的数据区域

K指要返回的最小值点在数据区域的位次

假设我们要查找这个数据集的最小值

我们在数组中选择A列数据集填入

在K中填入1

点击确定,马上就找到了最小值。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

■ 假设我们要查找这个数据集的倒数第三的值,只需将K 的值填入3。

点击确定,马上就找到了数据集中倒数第三的值。

》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘

这个函数在查找大数据集的时候非常实用,你学会了吗~

 

Keyword: 微信过滤

Excel表格技巧:巧用CHAR函数 将代码转换为字符

如何查询手机号是否注册过微信

本教程适用版本:WPS 365 点击免费使用

计算机内的每一个字符都有一个编码相对应,例如:字符A就有一个ANCI数字代码65相对应。大写字母A–Z相对应

的编码是65–90,小写字母a–z相对应的编码是97–122。

CHAR函数,就是根据其参数的ANCI数字代码返回字符。

我们在这个表格中实际操作一下帮助大家理解。

■ 选中B2单元格,点击插入函数,找到CHAR函数,点击确定。

在此,我们要输入数值。

数值是介意1至255之间的任意数字,该数字对应着要返回的字符。

我们选中A2填入,可以看到结果返回了该编码对应的字符。

>免费升级到企业版,赠超大存储空间

■ 将光标定位到B2单元格右下角,出现+字时选中下拉填充单元格,即可以批量的得出对应字符。

>免费升级到企业版,赠超大存储空间

是不是很神奇呢?