Trending February 2024 # How To Create A Simple 2D Platformer For Android In Unity # Suggested March 2024 # Top 4 Popular

You are reading the article How To Create A Simple 2D Platformer For Android In Unity updated in February 2024 on the website Flu.edu.vn. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested March 2024 How To Create A Simple 2D Platformer For Android In Unity

Jumping

Code

public void Jump() { chúng tôi = true; Grounding the player

At this point, you can hit play and test hitting space button to jump. There’s just one problem: you can jump infinitely! Hold down space or keep tapping the jump button and you can sore into the stratosphere… So we need a way to check if our player is on the ground and then only let him jump when he is on terra firma.

One way to do this is with ray casts. However, the easiest method for now is probably to just check whether the point beneath the player is ground or not. To do this, we’ll need to create a new ‘transform’ in our control script. A transform is simply a point in space with its own coordinates and rotation. We’ll call this groundCheck and add it the way we add any other variable. We’re also going to give that point a radius, we’re going to define a ‘layer mask’ (I’ll get to that) and we’re going to create a boolean called onGround.

To do this, just add the following to your script:

Code

public Transform groundCheck; public float groundCheckRadius; public LayerMask whatIsGround; private bool onGround;

You also need to add the following lines of code below:

Code

void FixedUpdate() { onGround = Physics2D.OverlapCircle(groundCheck.position, groundCheckRadius, whatIsGround); Creating platforms with prefabs and effectors Adding hazards

Code

public class Hazard : MonoBehaviour { private Controls player; public Transform start; void Start() { } void Update() { } void OnTriggerEnter2D(Collider2D other) { if (other.tag == "Player") { player.transform.position = start.position; } }

Just look at how evil this fella is!

Just create a new script called ObjectMove and then use this code:

Code

using UnityEngine; using System.Collections; public class ObjectMove : MonoBehaviour { public float amounttomovex; public float speed; private float currentposx; private float currentposy; private int facing; void Start() { currentposx = gameObject.transform.position.x; facing = 0; } void Update() { if (facing == 1 && gameObject.transform.position.x < currentposx - amounttomovex) { facing = 0; } { facing = 1; } if (facing == 0) { transform.Translate(Vector2.right * speed * Time.deltaTime); } else if (facing == 1) { transform.Translate(-Vector2.right * speed * Time.deltaTime); } } using System.Collections; public class DestroyParticle : MonoBehaviour { private ParticleSystem thisParticleSystem; void Start() { } void Update() { if (thisParticleSystem.isPlaying) { return; } Destroy(gameObject); } }

Don’t forget to add the script to the particle effect object. Name it ‘blood’ and put it in your prefabs, deleting the existing copy from your Hierarchy.

Now add this code to your ‘Hazard’ script in the onTriggerEnter before you move the player:

Code

Instantiate(Explode, player.transform.position, player.transform.rotation);

‘Instantiate’ simply means ‘create’ and you’ll use this for lots of other things too, such as spawning bad guys. You also need to create a public game object called Explode and hopefully at this point you know you’re going to need to drag that game object onto the script for each of your hazards (don’t forget your bad guys and your bounds!). I also created a new folder called ‘Audio’ and added an explosion sound effect which I also added to the particle system in the prefab. That way, as long as ‘Play On Awake’ is ticked, the sound will play each time the particle effect gets created!

For those of you who are getting a bit overly perfectionist about all this (like me…), you can swap out your death code for this to polish it up a little:

Code

void OnTriggerEnter2D(Collider2D other) { if (other.tag == "Player") { StartCoroutine("respawndelay"); } } public IEnumerator respawndelay() { Instantiate(Explode, player.transform.position, player.transform.rotation); player.enabled = false; yield return new WaitForSeconds(1); player.transform.position = start.position; player.enabled = true; }

What this code is doing is to move our death animation into a coroutine, which allows us to include a ‘wait’. This is a function that runs in the background and by pausing, we can put a beat in between the death and the respawn. I’ve also added some changes around that to make the player disappear and become unresponsive before going back to normal ready to play again. Lastly. I removed all momentum so it wouldn’t carry over when the player comes back. All this is optional but if you’re playing along you can lift it to add to your own code. And well, why not?

Coming next…

You're reading How To Create A Simple 2D Platformer For Android In Unity

How To Create A Chart In Microsoft Powerpoint

Because charts and graphs make such beautiful visuals, you may want to include one in your Microsoft PowerPoint presentation. You can create a chart within PowerPoint or insert one you create in Excel: two easy ways to add a helpful visual.

Also helpful: moving text from Word into PowerPoint? Learn how to copy formatted text from one to the other and save yourself time!

How to Create a Chart in PowerPoint

You can set up a chart in PowerPoint and add the data for it in one complete process. This gives you an excellent way to create a chart quickly and easily.

If you have a blank slide instead, add your chart by going to the “Insert” menu and selecting “Chart” in the Illustrations group.

To edit the data for your chart later, go to the “Chart Design” tab and open the “Edit Data” menu. Select either “Edit Data” or “Edit Data in Excel.”

Tip: if you use Google Slides in addition to PowerPoint, you can insert a chart in Slides, too!

How to Insert an Excel Chart in PowerPoint

Maybe you already have a chart in Microsoft Excel that you’d like to use in your PowerPoint slideshow. This is as simple as a copy and paste of the chart. Depending on how you want to update the chart later, there are a handful of ways to paste the chart into PowerPoint.

Go to the slide in PowerPoint where you want to insert the Excel chart. Select the “Paste” drop-down arrow on the “Home” tab, then choose one of the “Paste Options” described below.

Use Destination Theme & Embed Workbook: insert the chart with your PowerPoint theme.

Keep Source Formatting & Embed Workbook: retain the chart’s original formatting and insert it.

Use Destination Theme & Link Data: use your PowerPoint theme, insert the chart, and link the data.

Keep Source Formatting & Link Data: retain the chart’s formatting, insert it, and link the data.

Picture: insert the chart as a static image.

With the Picture option, you cannot edit or update the chart as the data changes. Like any other picture, this is a static image that is inserted in PowerPoint.

You’ll see your chart pop onto your slide using the paste option you chose.

Good to know: sometimes PowerPoint can be limiting, but these PowerPoint alternatives may offer more features for charts and other graphics.

How to Customize a Chart in PowerPoint

Whether you create the chart in PowerPoint or paste it from Excel, you can customize its elements and appearance.

Note: this does not apply if you paste the chart as an image.

Use the Chart Design Tab

Select the chart and go to the “Chart Design” tab that is displayed. Use the tools in the ribbon to customize the chart.

Add Chart Element: add or position items, such as axis titles, data labels, and a legend.

Quick Layout: choose a different style or layout for the chart.

Change Colors: choose a new color scheme for the chart.

Chart Styles: select a design for the chart.

Change Chart Type: choose a different type of chart or graph.

The items in the “Data” section of the ribbon may or may not be available, depending on how you paste the chart on your slide. For instance, you may be able to switch rows and columns, select the data for the chart, edit the data, or refresh the chart.

Use the Format Chart Sidebar or Format Tab

Use the available tools to make your changes.

Use the Chart Buttons on Windows

In PowerPoint on Windows, you can also use the three buttons that display to the right when you select the chart. These allow you to work with Chart Elements, Styles, and Filters.

You can add and remove items, choose a color scheme, or filter the chart according to specific data.

Frequently Asked Questions Why do I see the Picture Format tab when I select my chart?

When you select your chart in PowerPoint, you should see the “Chart Design” tab display. If you see the “Picture Format” tab instead, it means that you pasted the chart as a picture rather than a chart.

How can I stop accidentally moving or resizing my chart?

It can be easy to mistakenly move your chart or resize it slightly as you work on your slide. To avoid this, you can lock the chart.

Image credit: Pixabay. All screenshots by Sandy Writtenhouse.

Sandy Writtenhouse

With her BS in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She wanted to help others learn how technology can enrich business and personal lives and has shared her suggestions and how-tos across thousands of articles.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Sign up for all newsletters.

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

How To Create A Bubble Chart In Excel

Microsoft Excel makes it possible to create different types of charts, and one of them is the bubble chart. Some users may feel the need to create a Bubble Chart in Excel but have no idea how, and that’s fine because we have an idea of what to do. We should point out that a bubble chart is ideal for when a person wants to display three data series on a scatter plot, or a type of scatter plot. The question is, then, how do we get this done? It’s not hard because Microsoft Excel has already accomplished most of the work, and as such, there is no need to manually create a bubble chart from scratch.

How to create a Bubble Chart in Excel

Add a bubble chart to your work

Launch Microsoft Excel if you haven’t done so already.

Open the workbook with the relevant data from the main menu.

Select the data set for your bubble chart.

Add a bubble chart to your work

From there, you must seek out the Chart category located on the Ribbon.

Hover the mouse cursor over the icon with the tiny dots.

From the dropdown menu, you will see a list of bubble chart options to choose from.

Select the one that best fits your needs.

How to customize the Bubble Chart in Excel

In terms of customizing the bubble chart, this is a fairly simple task as well. Then again it all boils down to what you want to accomplish.

The Design tab

The Format tab

Format Chart Area

Chart Format buttons

Make changes to the chart data

1] The Design tab

From here you can apply a different layout, switch the rows and columns, add a new style, and more.

2] The Format tab

If you want to change the color, add WordArt, insert shapes, and more, then the Format tab is your friend.

From the tab, you will Format sitting next to Chart Design. Select it.

All the options available to you are located on the Ribbon.

Choose the options that make sense for your overall formatting needs.

3] Format Chart Area

From this area, you can color and text options.

Alternatively, folks can apply glow, shadow, border color, and much more.

4] Chart Format buttons

For additional formatting options to spice up your bubble chart in Excel, you can make use of the format buttons.

From the side, you should see three buttons.

They are called Chart Elements, Chart Styles, and Chart Filters.

Each option brings something unique to the table, so play around with them to find what changes you can make to the chart.

5] Make changes to the chart data

If you are not pleased with the data on your Excel bubble chart, then we would recommend performing an edit.

From the context menu, then, you must choose Select Data.

Make the relevant changes, but ensure you know exactly what you’re doing.

Read: How to use the ISEVEN function in Excel

Are Bubble Charts available in Excel?

From our understanding, bubble charts have been in Excel for quite some time, but in the latest version, these types of charts are easier to add and customize.

What is a bubble chart in Excel used for?

A bubble chart is used in Excel when a person wants to graphically represent three sets of data. Now, out of the three data sets used to create the bubble chart, two-axis of the chart in a series of XY coordinates are shown. After that, a third set shows the important data points.

How To Create A Rainbow Gradient In Photoshop

How to Create a Rainbow Gradient in Photoshop

Learn how to create a simple rainbow gradient in Photoshop, how to save it as a rainbow gradient preset, and the fastest way to add your rainbow colors to images, shapes or text! For Photoshop CC 2023.

Written by Steve Patterson.

In this tutorial, I show you how easy it is to create your own rainbow gradient in Photoshop and how to save it as a custom preset. You’ll also learn the fastest way to colorize an image with your rainbow colors, and how to add your rainbow gradient to text!

Along the way, we’ll be using the Gradients panel which is new as of Photoshop 2023. So for best results, make sure that your copy of Photoshop is up to date. You can get the latest Photoshop version here.

Let’s get started!

Creating a new group for your custom gradients

Before we learn how to create the rainbow gradient, let’s quickly create a new gradient group to store all of our custom gradients and keep them separate from Photoshop’s default gradients. If you have already created a custom group, you can skip this section.

Step 1: Open the Gradients panel

Start by opening the Gradients panel. You’ll find it in the same panel group as the Color, Swatches and Patterns panels.

Notice that all of Photoshop’s default gradients are divided into groups, like Basics, Blues, Purples, and so on. And each group is represented by a folder:

The Gradients panel.

Step 2: Open the Gradients panel menu

Rather than placing the rainbow gradient into one of these default groups, we’ll create our own custom group.

Step 3: Choose “New Gradient Group”

Then choose New Gradient Group from the menu:

Creating a new gradient group.

Step 4: Name the group “My Gradients”

The Group Name dialog box.

Then back in the Gradients panel, scroll down past the default groups and the new group will appear at the bottom, ready to hold our rainbow gradient:

The new “My Gradients” group.

See also: Give someone Rainbow Eye Colors in Photoshop!

How to create a rainbow gradient in Photoshop

Now let’s learn how to create the rainbow gradient. As we’ll see, it’s really just a matter of choosing an existing gradient and then editing the colors.

Step 1: Select the Gradient Tool

Start by selecting the Gradient Tool in the toolbar:

Choosing the Gradient Tool.

Step 2: Open the Gradient Editor Step 3: Select the “Black, White” gradient

Selecting the “Black, White” gradient in the Gradient Editor.

Step 4: Change the color black to red

Then go down to the gradient preview bar in the lower half of the Gradient Editor.

Setting R to 255, G to 0 and B to 0 for red.

Step 5: Set the location of red to 0%

Back in the Gradient Editor, make sure the Location value for red is set to 0%.

And we now have the first color of our rainbow:

Setting the location of red to 0 percent.

Step 6: Add a new color stop and choose yellow

Editing the color.

Setting R to 255, G to 255 and B to 0 for yellow.

Step 7: Set yellow’s location to 20%

And then back in the Gradient Editor, set the Location of yellow to 20%. Two colors down, four to go:

Setting the location of yellow to 20 percent.

Step 8: Add another color stop and choose green

Adding another new color stop.

Changing the new color.

Setting R to 0, G to 255 and B to 0 for green.

Step 9: Set green’s location to 40%

Set the Location of green to 40%:

Setting the location of green to 40 percent.

Step 10: Add another color step and choose cyan

The next color we need for our rainbow gradient is cyan.

Adding a third new color stop below the gradient.

And in the Color Picker, leave R at 0 and G at 255, but change B to 255:

Setting R to 0, G to 255 and B to 255 for cyan.

Setting the location of cyan to 60 percent.

Step 11: Add a new color stop and choose blue

We have one more color stop to add, and then we’ll edit the white color stop.

Adding a fourth new color stop.

Changing the color.

And in the Color Picker, choose blue by leaving R at 0, changing G to 0 and leaving B at 255:

Setting R to 0, G to 0 and B to 255 for blue.

Step 12: Set blue’s location to 80%

Setting the location of blue to 80 percent.

Step 13: Change the color white to magenta

The last color we need for our rainbow gradient is magenta.

In the Color Picker, choose magenta by changing R to 255 and leaving G at 0 and B at 255:

Setting R to 255, G to 0 and B to 255 for magenta.

Step 14: Set magenta’s location to 100%

And finally, make sure the Location value for magenta is at 100%.

And we now have our rainbow gradient:

Setting magenta’s location to 100 percent.

How to save the rainbow gradient as a preset

So now that we’ve created the rainbow gradient, let’s save it as a gradient preset. For this part, we’ll need the custom gradient group that we made back in the first part of the tutorial.

Step 1: Select your custom gradient group

Still in the Gradient Editor, select your custom group from the Presets area:

Selecting the “My Gradients” group.

Step 2: Name the gradient “Rainbow”

Change the name of the gradient from “Custom” to “Rainbow”:

Naming the gradient “Rainbow”.

Up next, I’ll show you the fastest way to apply the rainbow gradient to an image or to text:

The new rainbow gradient preset.

How to apply the rainbow gradient to an image

As of Photoshop CC 2023, the easiest way to apply the rainbow gradient to an image, a shape or text is by dragging and dropping it from the Gradients panel.

Here’s an image I’ve opened in Photoshop that I downloaded from Adobe Stock:

The original photo. Credit: Adobe Stock.

Step 1: Open the Gradients panel

To colorize an image with the rainbow gradient, open the Gradients panel:

Opening the Gradients panel.

Step 2: Drag the rainbow gradient onto the image

Choosing the rainbow gradient.

Then simply drag the gradient from the Gradients panel onto your image:

Dragging the gradient from the Gradients panel and dropping it on the image.

The gradient temporarily blocks the image from view.

I’ll show you how to change the direction of the colors in a moment:

The result after dragging and dropping the rainbow gradient.

Step 3: Change the Gradient fill layer’s blend mode

In the Layers panel, the gradient appears on its own Gradient fill layer above the image.

To blend the rainbow colors into the image, change the fill layer’s blend mode to either Color, Overlay or Soft Light. Each mode will give you a different result, so choose the one that looks best:

Changing the Gradient fill layer’s blend mode.

Step 4: Lower the layer opacity

If the colors are too intense, lower the Opacity of the fill layer. I’ll lower mine to 40 percent:

Lowering the layer’s opacity.

And here’s my result with the rainbow gradient set to the Overlay blend mode at 40 percent opacity:

The result with the rainbow gradient blended with the image.

Step 5: Change the gradient’s direction

This opens the Gradient Fill dialog box where you can edit various options.

To simply reverse the gradient colors, select the Reverse option. Or enter a new Angle value to change the gradient’s direction. For example, to display the gradient from left to right, set the angle to 0°. Or for a diagonal gradient, try 45°.

The Gradient Fill options.

Related: Learn ALL the new ways to add gradients in Photoshop!

How to add the rainbow gradient to text

It’s just as easy to apply the rainbow gradient to text. But there’s a difference in how we edit the gradient options:

A Photoshop document with white text in front of a black background.

Step 1: Drag the rainbow gradient onto the text

Make sure you drop it directly on one of the letters, not on the background:

Dragging and dropping the rainbow gradient onto the text.

By default, the initial result will look like this, with the gradient running vertically through the letters:

The initial result.

Step 2: Edit the Gradient Overlay layer effect

A moment ago, we saw that Photoshop applies gradients as Gradient fill layers when we drop them onto an image. But when we drop a gradient onto text, the gradient is applied as a Gradient Overlay layer effect.

Instead of opening the Gradient Fill dialog box, Photoshop opens the Layer Style dialog box where we find the same Reverse and Angle options.

To change the direction from vertical to horizontal, set the Angle to 0°:

The Reverse and Angle options for the Gradient Overlay.

And the rainbow gradient now runs through the text from left to right:

The final rainbow text effect.

Where to go next

And there we have it! That’s how to create a rainbow gradient, how to save the gradient as a preset, and how to add the rainbow colors to an image or text in Photoshop!

Check out our Photoshop Basics section for more tutorials. And don’t forget, all of our Photoshop tutorials are available to download as PDFs!

How To Create A Candlestick Chart In Matplotlib?

Candlestick charts are a popular way to visualize stock market data. They show the opening, closing, high, and low prices of a stock or security for a given time period. A candlestick chart consists of a series of vertical bars or “candlesticks”, where each candlestick represents one time period. The top and bottom of each candlestick represent the highest and lowest prices traded during that period, while the body of the candlestick represents the opening and closing prices.

In this tutorial, we will explore codes where we will use Matplotlib, a popular data visualization library in Python, to create a candlestick chart for a week of stock prices.

We will use the Pandas library to create a DataFrame representing the stock prices and then use Matplotlib’s bar chart function to plot the candlesticks.

To create a candlestick chart, we use a specific syntax that involves using the chúng tôi method in Matplotlib.

plt.bar to Create Bar Charts

plt.bar is a function in the Matplotlib library that allows you to create bar charts in Python. It takes several parameters, including the x-axis values, y-axis values, width of the bars, and colour of the bars. You can use this function to create both horizontal and vertical bar charts, and you can customize the appearance of the bars to suit your needs.

Below is the syntax for plt.bar.

plt.bar(up.index,up.close-up.open,bottom=up.open,color) The "up" dataframe contains the stock prices where the closing price is greater than or equal to the opening price. plt.bar(down.index, down.close - down.open, bottom=down.open, color) The "down" dataframe contains the stock prices where the closing price is less than the opening price. Example: Candlestick Chart in Matplotlib

Now let’s explore the code shown below. This code creates a candlestick chart to represent the opening, closing, high, and low prices of a stock for a week using the matplotlib library in Python.

First, a Pandas DataFrame is created to store the stock prices of the week. Then, two new DataFrames are created – “up” stores the stock prices where the closing stock price is greater than or equal to the opening stock price, and “down” stores the stock prices where the closing stock price is lesser than the opening stock price.

Next, the colours for the candlesticks are defined: “green” for increased stock prices and “red” for decreased stock prices. The width of the candlestick elements is also set.

Then, the chúng tôi method is used to plot the up and down stock prices on the chart, where the bottom parameter specifies the starting point of each bar. The x-axis tick labels are rotated by 45 degrees towards the right for better visibility. Finally, the chart is labelled with a title, x-label, y-label, and displayed using plt.show().

import pandas as pd import matplotlib.pyplot as plt # Create a DataFrame to represent opening, closing, high, and low prices # of a stock for a week stock_prices = pd.DataFrame({'open': [60, 70, 80, 90, 100, 110, 120], 'close': [55, 85, 75, 100, 95, 120, 105], 'high': [70, 95, 85, 110, 105, 120, 125], 'low': [50, 60, 70, 80, 85, 105, 100]}, index=pd.date_range("2023-04-01", periods=7, freq="d")) plt.figure() # Create a new DataFrame called "up" that stores the stock_prices # when the closing stock price is greater than or equal to the opening stock price # Create a new DataFrame called "down" that stores the stock_prices # when the closing stock price is lesser than the opening stock price down = stock_prices[stock_prices.close < stock_prices.open] # When the stock prices have decreased, then it # will be represented by red color candlestick col1 = 'red' # When the stock prices have increased, then it # will be represented by green color candlestick col2 = 'green' # Set the width of candlestick elements width = 0.4 width2 = 0.05 # Plot the up prices of the stock plt.bar(up.index, up.close-up.open, width, bottom=up.open, color=col2) plt.bar(up.index, up.high-up.close, width2, bottom=up.close, color=col2) plt.bar(up.index, up.low-up.open, width2, bottom=up.open, color=col2) # Plot the down prices of the stock plt.bar(down.index, down.close-down.open, width, bottom=down.open, color=col1) plt.bar(down.index, down.high-down.open, width2, bottom=down.open, color=col1) plt.bar(down.index, down.low-down.close, width2, bottom=down.close, color=col1) # Rotate the x-axis tick labels at 45 degrees towards right plt.xticks(rotation=45, ha='right') # Display the candlestick chart of stock data for a week plt.title('Stock Prices for a Week') plt.xlabel('Date') plt.ylabel('Price (USD)') plt.show() Output

On executing, you will get the following candlestick chart:

Conclusion

In conclusion, creating a candlestick chart in Matplotlib can be a powerful tool for visualizing stock market data. Through the use of different colours and widths, it is also possible to convey additional information about how stock prices have changed over time. By following the steps outlined in this tutorial, you can create your own candlestick chart and gain deeper insights into market trends and stock performance.

How To Quickly Create A Waffle Chart In Excel

Have you heard of the Waffle Chart (also called the square pie chart)? I have seen these in a lot of dashboards and news article graphics, and I find these really cool. A lot of times, these are used as an alternative to the pie charts.

Here is an example of a waffle chart (shown below):

In the above example, there are three waffle charts for the three KPIs. Each waffle chart is a grid of 100 boxes (10X10) where each box represents 1%. The colored boxes indicate the extent to which the goal was achieved with 100% being the overall goal.

What do I like in a Waffle Chart?

A waffle chart looks cool and can jazz up your dashboard.

It’s really simple to read and understand. In the KPI waffle chart shown above, each chart has one data point and a quick glance would tell you the extent of the goal achieved per KPI.

It grabs readers attention and can effectively be used to highlight a specific metric/KPI.

It doesn’t misrepresent or distort a data point (which a pie chart is sometimes guilty of doing).

What are the shortcomings?

In terms of value, it’s no more than a data point (or a few data points). It’s almost equivalent to having the value in a cell (without all the colors and jazz).

It takes some work to create it in Excel (not as easy as a bar/column or a pie chart).

You can try and use more than one data point per waffle chart as shown below, but as soon as you go beyond a couple of data points, it gets confusing. In the example below, having 3 data points in the chart was alright, but trying to show 6 data points makes it horrible to read (the chart loses its ability to quickly show a comparison).

Now let’s learn to create a waffle chart in Excel using Conditional Formatting.

Download the Example file to follow along.

While creating a waffle chart, I have Excel dashboards in mind. This means that the chart needs to be dynamic (i.e., update when a user changes selections in a dashboard).

Something as shown below:

Creating a waffle chart using conditional formatting is a three-step process:

Creating the Waffle Chart within the Grid.

Creating the Labels.

Creating a Linked Picture that can be used in Excel Dashboards.

In a worksheet, select a grid of 10 rows and 10 columns and resize it to make it look like the grid as shown in the waffle charts.

In the 10X10 grid, enter the values with 1% in the bottom-left cell of the grid (C11 in this case) and 100% in the top-right cell of the grid (L2 in this case). You can either enter it manually or use a formula. Here is the formula that will work for the specified range of cells (you can modify the references to work in any grid of cells):

=( COLUMNS ($C2:C$11)+10*( ROWS (C2:$C$11)-1))/100

The font size in the image above has been reduced to make the values visible.

In the New Formatting Rule dialog box, select Format Only cells that contain and specify the value to be between 0 and A2 (the cell that contains the KPI value).

With the grid selected, change the fill color and the font color to a lighter shade of the color used in conditional formatting. In this case, since we have used Green color to highlight cells, we can use a lighter shade of green.

Apply ‘All Border’ format using white border color.

Give an outline to the grid with a gray ‘Outside Borders’ format.

This will create the waffle chart within the grid. Also, this waffle chart is dynamic as it is linked to cell A2. If you change the value in cell A2, the waffle chart would automatically update.

Now the next step is to create a label that is linked to the KPI value (in cell A2).

With the text box selected, enter =A2 in the formula bar. This would link the text box to cell A2 and any change in the cell value would also be reflected in the text box.

Format the text box and place it in the waffle chart grid.

The waffle chart is now complete, but it can’t be used in a dashboard in its current form. To use it in a dashboard, we need to take a picture of this waffle chart and put it in the dashboard, such that it can be treated as an object.

Select the cells that make the waffle chart.

Copy these cells (Ctrl + C).

This will create a picture that is linked to the waffle chart. You can now place this picture anywhere in the worksheet or even in any other worksheet of the same workbook. Since this picture is a copy of the cells that have the waffle chart, whenever the chart would update, this linked picture would also update.

Download the Example file.

Learn to create world-class dashboards in Excel. Join the Excel Dashboard Course.

You May Also Like the Following Excel Charting Tutorials:

Update the detailed information about How To Create A Simple 2D Platformer For Android In Unity on the Flu.edu.vn website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!