How To Make Comparative Bar Graph In Excel

Creating comparative bar graphs in Excel is simplified with COMPARE.EDU.VN, empowering you to visually analyze data and make informed decisions. This guide elucidates the process of generating impactful comparative bar graphs, unlocking insights and improving decision-making capabilities, and providing you with the graphing tools to create effective data visualization. Optimize your data analysis with these comparative bar graph tips.

1. Understanding the Comparative Bar Graph

A comparative bar graph, also known as a comparative bar chart, is a visual tool used to compare different categories or groups of data. It displays data as rectangular bars with lengths proportional to the values they represent. This type of graph is particularly useful when you want to show the differences between various items or track changes over time. The essence of making a comparative bar graph in Excel lies in presenting data in a clear, understandable format that highlights key comparisons and trends. This method of data visualization is fundamental for anyone looking to analyze and interpret data effectively.

1.1 Types of Comparative Bar Graphs

Excel offers several types of bar graphs that can be used for comparative analysis. Understanding these types is crucial for selecting the most appropriate one for your data.

• Clustered Bar Graph: This type displays bars for different categories side-by-side, making it easy to compare values across categories for each group. It’s ideal for comparing multiple sets of data at once.

• Stacked Bar Graph: Stacked bar graphs show the contribution of each category to the total value of a group. Each bar represents the total, and different segments within the bar represent different categories. This is useful for showing proportions and overall totals.

• 100% Stacked Bar Graph: This type is similar to the stacked bar graph, but each bar represents 100% of the total. The segments within the bar show the percentage contribution of each category. This is useful for comparing the relative proportions of different categories across groups.

• 3D Bar Graph: While not always the best choice for data clarity, 3D bar graphs can add visual appeal. However, they can sometimes distort the data, so use them judiciously.

Choosing the right type of bar graph depends on the nature of your data and what you want to highlight. Clustered bar graphs are great for direct comparisons, while stacked bar graphs are better for showing parts of a whole.

1.2 Benefits of Using Comparative Bar Graphs

Comparative bar graphs offer several benefits for data analysis and presentation.

• Easy Comparison: They allow for quick and easy comparison of data across different categories. The visual representation makes it simple to identify trends and differences.
• Clear Visualization: Bar graphs provide a clear and concise way to visualize data, making it accessible to a wide audience, including those without technical expertise.
• Effective Communication: They are an effective tool for communicating insights and findings to stakeholders, helping to inform decision-making processes.
• Data-Driven Decisions: By highlighting key trends and comparisons, bar graphs enable data-driven decision-making, helping organizations to make informed choices based on evidence.
• Trend Identification: They make it easy to identify trends and patterns in data, such as increases or decreases over time or differences between groups.

2. Preparing Your Data in Excel

Before you can create a comparative bar graph in Excel, you need to prepare your data correctly. This involves organizing your data in a way that Excel can easily interpret and use to generate the graph. Proper data preparation is essential for creating accurate and meaningful visualizations.

2.1 Structuring Your Data

The way you structure your data in Excel will directly affect how the bar graph is created. Here are some best practices for structuring your data.

• Column Headers: Ensure that your data has clear and descriptive column headers. These headers will be used as labels in your graph, so they should accurately represent the data in each column.
• Consistent Data Types: Make sure that each column contains consistent data types. For example, if you’re comparing sales figures, ensure that all values in the sales columns are numbers.
• Categorical Variables: Place your categorical variables (the items you want to compare) in the first column. This will typically be the x-axis of your bar graph.
• Numerical Data: Place your numerical data (the values you want to compare) in the subsequent columns. Each column will represent a different category or group.
• Clean Data: Remove any unnecessary rows or columns that could confuse Excel. Ensure that there are no empty cells within your data range.

2.2 Example Data Setup

Let’s consider an example where you want to compare the sales of three products (Product A, Product B, and Product C) over four quarters. Your data should be structured as follows.

Quarter	Product A	Product B	Product C
Q1	100	150	120
Q2	120	180	140
Q3	140	200	160
Q4	160	220	180

In this setup, the “Quarter” column contains the categorical variable, and the “Product A,” “Product B,” and “Product C” columns contain the numerical data.

2.3 Cleaning and Formatting Data

Before creating the graph, it’s important to clean and format your data to ensure accuracy and clarity.

• Remove Errors: Check for and correct any errors in your data, such as typos or incorrect values.
• Format Numbers: Format your numerical data consistently. Use the same number of decimal places and the appropriate currency symbols if necessary.
• Remove Duplicates: Check for and remove any duplicate rows that could skew your results.
• Sort Data: Sort your data if necessary to make it easier to identify trends or patterns.
• Use Tables: Convert your data range into an Excel table. This makes it easier to manage and update your data, and it also allows Excel to automatically adjust the graph if you add or remove data.

3. Creating a Clustered Bar Graph in Excel

A clustered bar graph is one of the most common and effective types of comparative bar graphs. It displays bars for different categories side-by-side, making it easy to compare values across categories for each group. Here’s how to create one in Excel.

3.1 Selecting Your Data

The first step in creating a clustered bar graph is to select the data you want to include in the graph.

1. Select the Data Range: Click and drag your mouse to select the entire data range, including the column headers and all the data rows.
2. Ensure Headers are Included: Make sure that your selection includes the column headers. Excel will use these headers as labels for the categories in your graph.
3. Avoid Empty Rows or Columns: Ensure that there are no empty rows or columns within your selection. These can cause errors or unexpected results in your graph.

3.2 Inserting the Bar Graph

Once you have selected your data, you can insert the bar graph into your worksheet.

1. Go to the Insert Tab: Click on the “Insert” tab in the Excel ribbon.
2. Choose the Bar Graph Type: In the “Charts” group, click on the “Insert Column or Bar Chart” button. A dropdown menu will appear with various bar graph options.
3. Select Clustered Column: Under the “2-D Column” section, select the “Clustered Column” option. This will insert a basic clustered bar graph into your worksheet.

3.3 Customizing the Graph

After inserting the bar graph, you can customize it to make it more informative and visually appealing.

1. Chart Title: Click on the chart title to edit it. Enter a descriptive title that accurately reflects the data being displayed. For example, “Product Sales by Quarter.”
2. Axis Titles: Add axis titles to label the x-axis and y-axis. This helps viewers understand what the graph is showing. To add axis titles, click on the graph, then click on the “+” icon next to the graph. Check the “Axis Titles” box, and then click on each axis title to edit it.
3. Data Labels: Add data labels to display the exact values for each bar. This can make it easier to compare values and identify trends. To add data labels, click on the graph, then click on the “+” icon next to the graph. Check the “Data Labels” box.
4. Legend: The legend identifies the different categories in the graph. You can customize the legend by clicking on it and dragging it to a different location or by changing its formatting.
5. Colors and Styles: Change the colors and styles of the bars, axes, and background to make the graph more visually appealing. Click on the graph, then go to the “Format” tab in the Excel ribbon. Use the options in the “Shape Styles” and “WordArt Styles” groups to customize the appearance of the graph.
6. Gridlines: Adjust the gridlines to make the graph easier to read. You can show or hide gridlines, change their color, and adjust their spacing.
7. Chart Area: Adjust the size and position of the chart area to fit your worksheet. You can also change the background color and add borders to the chart area.

3.4 Example of a Clustered Bar Graph

Clustered Bar Graph Example

This clustered bar graph shows the sales of three products (Product A, Product B, and Product C) over four quarters. The bars are grouped by quarter, making it easy to compare the sales of each product within each quarter. The graph includes a descriptive title, axis titles, data labels, and a legend.

4. Creating a Stacked Bar Graph in Excel

A stacked bar graph is another useful type of comparative bar graph. It shows the contribution of each category to the total value of a group. Each bar represents the total, and different segments within the bar represent different categories. This is useful for showing proportions and overall totals.

4.1 Selecting Your Data

The first step in creating a stacked bar graph is to select the data you want to include in the graph.

1. Select the Data Range: Click and drag your mouse to select the entire data range, including the column headers and all the data rows.
2. Ensure Headers are Included: Make sure that your selection includes the column headers. Excel will use these headers as labels for the categories in your graph.
3. Avoid Empty Rows or Columns: Ensure that there are no empty rows or columns within your selection. These can cause errors or unexpected results in your graph.

4.2 Inserting the Bar Graph

Once you have selected your data, you can insert the bar graph into your worksheet.

1. Go to the Insert Tab: Click on the “Insert” tab in the Excel ribbon.
2. Choose the Bar Graph Type: In the “Charts” group, click on the “Insert Column or Bar Chart” button. A dropdown menu will appear with various bar graph options.
3. Select Stacked Column: Under the “2-D Column” section, select the “Stacked Column” option. This will insert a basic stacked bar graph into your worksheet.

4.3 Customizing the Graph

After inserting the bar graph, you can customize it to make it more informative and visually appealing.

1. Chart Title: Click on the chart title to edit it. Enter a descriptive title that accurately reflects the data being displayed. For example, “Product Sales by Quarter.”
2. Axis Titles: Add axis titles to label the x-axis and y-axis. This helps viewers understand what the graph is showing. To add axis titles, click on the graph, then click on the “+” icon next to the graph. Check the “Axis Titles” box, and then click on each axis title to edit it.
3. Data Labels: Add data labels to display the exact values for each segment of the bar. This can make it easier to compare values and identify trends. To add data labels, click on the graph, then click on the “+” icon next to the graph. Check the “Data Labels” box.
4. Legend: The legend identifies the different categories in the graph. You can customize the legend by clicking on it and dragging it to a different location or by changing its formatting.
5. Colors and Styles: Change the colors and styles of the bars, axes, and background to make the graph more visually appealing. Click on the graph, then go to the “Format” tab in the Excel ribbon. Use the options in the “Shape Styles” and “WordArt Styles” groups to customize the appearance of the graph.
6. Gridlines: Adjust the gridlines to make the graph easier to read. You can show or hide gridlines, change their color, and adjust their spacing.
7. Chart Area: Adjust the size and position of the chart area to fit your worksheet. You can also change the background color and add borders to the chart area.

4.4 Example of a Stacked Bar Graph

This stacked bar graph shows the sales of three products (Product A, Product B, and Product C) over four quarters. Each bar represents the total sales for a quarter, and the segments within the bar represent the contribution of each product to the total sales. The graph includes a descriptive title, axis titles, data labels, and a legend.

5. Creating a 100% Stacked Bar Graph in Excel

A 100% stacked bar graph is similar to the stacked bar graph, but each bar represents 100% of the total. The segments within the bar show the percentage contribution of each category. This is useful for comparing the relative proportions of different categories across groups.

5.1 Selecting Your Data

The first step in creating a 100% stacked bar graph is to select the data you want to include in the graph.

1. Select the Data Range: Click and drag your mouse to select the entire data range, including the column headers and all the data rows.
2. Ensure Headers are Included: Make sure that your selection includes the column headers. Excel will use these headers as labels for the categories in your graph.
3. Avoid Empty Rows or Columns: Ensure that there are no empty rows or columns within your selection. These can cause errors or unexpected results in your graph.

5.2 Inserting the Bar Graph

Once you have selected your data, you can insert the bar graph into your worksheet.

1. Go to the Insert Tab: Click on the “Insert” tab in the Excel ribbon.
2. Choose the Bar Graph Type: In the “Charts” group, click on the “Insert Column or Bar Chart” button. A dropdown menu will appear with various bar graph options.
3. Select 100% Stacked Column: Under the “2-D Column” section, select the “100% Stacked Column” option. This will insert a basic 100% stacked bar graph into your worksheet.

5.3 Customizing the Graph

After inserting the bar graph, you can customize it to make it more informative and visually appealing.

1. Chart Title: Click on the chart title to edit it. Enter a descriptive title that accurately reflects the data being displayed. For example, “Product Sales by Quarter.”
2. Axis Titles: Add axis titles to label the x-axis and y-axis. This helps viewers understand what the graph is showing. To add axis titles, click on the graph, then click on the “+” icon next to the graph. Check the “Axis Titles” box, and then click on each axis title to edit it.
3. Data Labels: Add data labels to display the percentage contribution of each segment of the bar. This can make it easier to compare values and identify trends. To add data labels, click on the graph, then click on the “+” icon next to the graph. Check the “Data Labels” box.
4. Legend: The legend identifies the different categories in the graph. You can customize the legend by clicking on it and dragging it to a different location or by changing its formatting.
5. Colors and Styles: Change the colors and styles of the bars, axes, and background to make the graph more visually appealing. Click on the graph, then go to the “Format” tab in the Excel ribbon. Use the options in the “Shape Styles” and “WordArt Styles” groups to customize the appearance of the graph.
6. Gridlines: Adjust the gridlines to make the graph easier to read. You can show or hide gridlines, change their color, and adjust their spacing.
7. Chart Area: Adjust the size and position of the chart area to fit your worksheet. You can also change the background color and add borders to the chart area.

5.4 Example of a 100% Stacked Bar Graph

This 100% stacked bar graph shows the sales of three products (Product A, Product B, and Product C) over four quarters. Each bar represents 100% of the total sales for a quarter, and the segments within the bar represent the percentage contribution of each product to the total sales. The graph includes a descriptive title, axis titles, data labels, and a legend.

6. Enhancing Your Bar Graph with Excel Features

Excel offers a variety of features that can enhance your bar graph and make it more informative and visually appealing.

6.1 Adding Error Bars

Error bars can be used to show the variability or uncertainty in your data. They are particularly useful when you are comparing data that has been collected from samples.

1. Select the Data Series: Click on the data series that you want to add error bars to.
2. Go to the Error Bars Options: Click on the “Chart Tools” tab in the Excel ribbon, then click on the “Layout” tab. In the “Analysis” group, click on the “Error Bars” button.
3. Choose the Error Bar Type: Select the type of error bar you want to add. You can choose from standard error bars, percentage error bars, or custom error bars.
4. Customize the Error Bars: Customize the error bars by specifying the error amount, direction, and style.

6.2 Adding Trendlines

Trendlines can be used to show the overall trend in your data. They are particularly useful when you are tracking changes over time.

1. Select the Data Series: Click on the data series that you want to add a trendline to.
2. Go to the Trendline Options: Click on the “Chart Tools” tab in the Excel ribbon, then click on the “Layout” tab. In the “Analysis” group, click on the “Trendline” button.
3. Choose the Trendline Type: Select the type of trendline you want to add. You can choose from linear, exponential, logarithmic, polynomial, power, or moving average trendlines.
4. Customize the Trendline: Customize the trendline by specifying the trendline options, such as the trendline name, equation, and R-squared value.

6.3 Adding Data Tables

Data tables can be used to display the data values directly below the graph. This can make it easier to compare values and identify trends.

1. Select the Graph: Click on the graph to select it.
2. Go to the Data Table Options: Click on the “Chart Tools” tab in the Excel ribbon, then click on the “Layout” tab. In the “Labels” group, click on the “Data Table” button.
3. Choose the Data Table Type: Select the type of data table you want to add. You can choose from data table with legend keys or data table without legend keys.
4. Customize the Data Table: Customize the data table by specifying the data table options, such as the data table format and position.

7. Tips for Effective Comparative Bar Graphs

Creating effective comparative bar graphs requires careful consideration of design principles and best practices. Here are some tips to help you create bar graphs that are clear, informative, and visually appealing.

7.1 Choosing the Right Colors

Color is an important element of any bar graph. Choose colors that are visually appealing and easy to distinguish.

• Use Contrasting Colors: Use contrasting colors to differentiate between the different categories in your graph. This makes it easier to compare values and identify trends.
• Avoid Too Many Colors: Avoid using too many colors, as this can make the graph look cluttered and confusing. Stick to a limited color palette of 2-3 colors.
• Consider Color Blindness: Consider color blindness when choosing colors. Use colors that are easily distinguishable by people with color blindness.
• Use Color to Highlight Key Data: Use color to highlight key data points or trends. For example, you could use a brighter color to emphasize the highest value in the graph.

7.2 Labeling Clearly

Clear and accurate labeling is essential for making your bar graph understandable.

• Use Descriptive Titles: Use descriptive titles for the graph and the axes. The titles should accurately reflect the data being displayed and the purpose of the graph.
• Label All Categories: Label all categories in the graph, including the x-axis and y-axis. This helps viewers understand what the graph is showing.
• Use Clear and Concise Labels: Use clear and concise labels that are easy to read. Avoid using abbreviations or technical jargon that may not be familiar to all viewers.
• Position Labels Strategically: Position labels strategically to avoid cluttering the graph. For example, you could rotate the x-axis labels to make them easier to read.

7.3 Ordering the Bars

The order in which the bars are displayed can affect how viewers interpret the graph.

• Order by Value: Order the bars by value to make it easier to compare values and identify trends. You can order the bars in ascending or descending order, depending on your preference.
• Order by Category: Order the bars by category to group related items together. This can be useful when you want to show the relationships between different categories.
• Maintain Consistency: Maintain consistency in the order of the bars across multiple graphs. This makes it easier to compare data across different graphs.

7.4 Avoiding Clutter

Clutter can make your bar graph difficult to read and understand.

• Remove Unnecessary Elements: Remove any unnecessary elements from the graph, such as gridlines, borders, or backgrounds.
• Use White Space: Use white space to separate the different elements of the graph. This makes the graph look cleaner and more organized.
• Simplify the Design: Simplify the design of the graph to focus on the key data points. Avoid using unnecessary decorations or visual effects.

7.5 Choosing the Right Graph Type

Choosing the right type of bar graph is essential for effectively communicating your data.

• Clustered Bar Graph: Use a clustered bar graph when you want to compare values across categories for each group.
• Stacked Bar Graph: Use a stacked bar graph when you want to show the contribution of each category to the total value of a group.
• 100% Stacked Bar Graph: Use a 100% stacked bar graph when you want to compare the relative proportions of different categories across groups.

8. Advanced Techniques for Comparative Bar Graphs

For more sophisticated data analysis, consider these advanced techniques to elevate your comparative bar graphs.

8.1 Using Pivot Tables for Data Aggregation

Pivot tables are a powerful tool for summarizing and aggregating data in Excel. They can be used to create comparative bar graphs that show the relationships between different variables.

1. Create a Pivot Table: Select your data range and click on the “Insert” tab in the Excel ribbon. In the “Tables” group, click on the “PivotTable” button.
2. Choose the Pivot Table Options: Choose the pivot table options, such as the pivot table location and the data fields to include in the pivot table.
3. Arrange the Pivot Table Fields: Arrange the pivot table fields to create the desired data summary. For example, you could place the categorical variable in the “Rows” area and the numerical data in the “Values” area.
4. Create a Bar Graph from the Pivot Table: Select the pivot table and click on the “Insert” tab in the Excel ribbon. In the “Charts” group, click on the “Insert Column or Bar Chart” button. Choose the type of bar graph you want to create.

8.2 Combining Bar Graphs with Other Chart Types

Combining bar graphs with other chart types, such as line graphs or scatter plots, can provide additional insights into your data.

1. Create a Combination Chart: Select your data range and click on the “Insert” tab in the Excel ribbon. In the “Charts” group, click on the “Insert Combo Chart” button.
2. Choose the Chart Types: Choose the chart types for each data series. For example, you could use a bar graph for one data series and a line graph for another data series.
3. Customize the Chart: Customize the chart by adding titles, labels, and legends.

8.3 Using Conditional Formatting

Conditional formatting can be used to highlight key data points or trends in your bar graph.

1. Select the Data Range: Select the data range that you want to apply conditional formatting to.
2. Go to the Conditional Formatting Options: Click on the “Home” tab in the Excel ribbon. In the “Styles” group, click on the “Conditional Formatting” button.
3. Choose the Conditional Formatting Rule: Choose the conditional formatting rule you want to apply. For example, you could use a color scale to highlight the highest and lowest values in the data range.
4. Customize the Conditional Formatting Rule: Customize the conditional formatting rule by specifying the formatting options, such as the color scale, data bars, or icon sets.

9. Common Mistakes to Avoid

Creating effective comparative bar graphs requires attention to detail. Here are some common mistakes to avoid.

9.1 Misrepresenting Data

Misrepresenting data can lead to inaccurate conclusions and poor decision-making.

• Use Accurate Scales: Use accurate scales for the axes. Avoid truncating the y-axis, as this can exaggerate differences between values.
• Avoid Distorting Bars: Avoid distorting the bars in the graph. Ensure that the bars are proportional to the values they represent.
• Provide Context: Provide context for the data being displayed. Include descriptive titles, labels, and legends.

9.2 Using Inappropriate Graph Types

Using an inappropriate graph type can make it difficult to understand the data.

• Choose the Right Graph Type: Choose the right graph type for the data being displayed. Use a clustered bar graph when you want to compare values across categories for each group. Use a stacked bar graph when you want to show the contribution of each category to the total value of a group. Use a 100% stacked bar graph when you want to compare the relative proportions of different categories across groups.
• Avoid 3D Graphs: Avoid using 3D graphs, as they can distort the data and make it difficult to read.

9.3 Overcomplicating the Graph

Overcomplicating the graph can make it difficult to understand and interpret.

• Simplify the Design: Simplify the design of the graph to focus on the key data points. Avoid using unnecessary decorations or visual effects.
• Remove Unnecessary Elements: Remove any unnecessary elements from the graph, such as gridlines, borders, or backgrounds.
• Use White Space: Use white space to separate the different elements of the graph. This makes the graph look cleaner and more organized.

10. Case Studies: Effective Use of Comparative Bar Graphs

Let’s explore some real-world examples of how comparative bar graphs can be used effectively.

10.1 Sales Performance Analysis

A company uses a clustered bar graph to compare the sales performance of different products across different regions. The graph shows the sales of each product in each region, making it easy to identify which products are performing well in each region.

10.2 Market Share Comparison

A market research firm uses a 100% stacked bar graph to compare the market share of different companies in a particular industry. The graph shows the percentage of the market that each company controls, making it easy to see which companies are the market leaders.

10.3 Employee Satisfaction Survey

A human resources department uses a stacked bar graph to compare the employee satisfaction levels across different departments. The graph shows the percentage of employees in each department who are satisfied with different aspects of their job, such as pay, benefits, and work-life balance.

11. Frequently Asked Questions (FAQ)

11.1 How do I change the color of the bars in my graph?

To change the color of the bars in your graph, click on the bars you want to change, then go to the “Format” tab in the Excel ribbon. Use the options in the “Shape Styles” group to customize the color of the bars.

11.2 How do I add axis titles to my graph?

To add axis titles to your graph, click on the graph, then click on the “+” icon next to the graph. Check the “Axis Titles” box, and then click on each axis title to edit it.

11.3 How do I add data labels to my graph?

To add data labels to your graph, click on the graph, then click on the “+” icon next to the graph. Check the “Data Labels” box.

11.4 How do I change the chart title?

To change the chart title, click on the chart title to edit it. Enter a descriptive title that accurately reflects the data being displayed.

11.5 How do I create a legend for my graph?

Excel automatically creates a legend for your graph based on the data series you include in the graph. You can customize the legend by clicking on it and dragging it to a different location or by changing its formatting.

11.6 How do I add error bars to my graph?

To add error bars to your graph, click on the data series that you want to add error bars to. Click on the “Chart Tools” tab in the Excel ribbon, then click on the “Layout” tab. In the “Analysis” group, click on the “Error Bars” button. Choose the type of error bar you want to add.

11.7 How do I add a trendline to my graph?

To add a trendline to your graph, click on the data series that you want to add a trendline to. Click on the “Chart Tools” tab in the Excel ribbon, then click on the “Layout” tab. In the “Analysis” group, click on the “Trendline” button. Choose the type of trendline you want to add.

11.8 How do I add a data table to my graph?

To add a data table to your graph, click on the graph to select it. Click on the “Chart Tools” tab in the Excel ribbon, then click on the “Layout” tab. In the “Labels” group, click on the “Data Table” button. Choose the type of data table you want to add.

11.9 What is a clustered bar graph?

A clustered bar graph is a type of bar graph that displays bars for different categories side-by-side, making it easy to compare values across categories for each group.

11.10 What is a stacked bar graph?

A stacked bar graph is a type of bar graph that shows the contribution of each category to the total value of a group. Each bar represents the total, and different segments within the bar represent different categories.

12. Conclusion: Mastering Comparative Bar Graphs in Excel

Creating comparative bar graphs in Excel is a valuable skill for anyone who works with data. By following the steps outlined in this guide, you can create clear, informative, and visually appealing bar graphs that help you analyze data and make informed decisions. Remember to prepare your data correctly, choose the right graph type, customize the graph to make it more informative, and avoid common mistakes. With practice, you can master the art of creating comparative bar graphs in Excel and use them to gain valuable insights from your data.

Are you looking to compare different options and make informed decisions? Visit compare.edu.vn at 333 Comparison Plaza, Choice City, CA 90210, United States, or contact us via WhatsApp at +1 (626) 555-9090, to find detailed and objective comparisons that will help you choose the best option for your needs. Our comprehensive comparisons provide clear insights and help you make smarter choices.