Question: Write a macro in Excel that draws a bar diagram as given in the imagebased on the provided cation / anion analysis of a water

Write a macro in Excel that draws a bar diagram as given in the imagebased on the provided cation/anion analysis of a water sample. The unit for the bar diagram should be mg/L as CaCO3/L. The size of the rectangular shapes should change in proportion to the concentration of each ion.
Please calculate alkalinity, carbonate hardness and noncarbonate hardness as well.
Write a macro in Excel that draws a bar diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Civil Engineering Questions!

Q:

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Q:

Location Income ($1,000) Urban 27 Rural 25 Suburban 25 Suburban 26 Rural 30 Urban 29 Rural 33 Urban 30 Suburban 32 Urban 34 Urban 35 Urban 40 Rural 30 Rural 33 Urban 42 Suburban 32 Urban 43 Urban 43...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

PINE TREES, INC. Memo To: Daniel Martinez, Manager of Risk Management Department From: Erica Marcus, Supervisor, Sales Department Date: February 20, 2006 Re: Burger Ranch...

Q:

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

Q:

The scribes of ancient Egypt were the forerunners of today's accountants. a. True b. False Possible Exam 1 Questions Chapter 1: 3. The scribes of ancient Egypt were the forerunners of today's...

Q:

WBS for a project. List of resources and allocate resources based on the tasks you identified Resource allocation plan ADDITIONAL CASES INTRODUCTION This document provides four cases in addition to...

Q:

For some years now, you've owned a small specialty bookshop in a college town. You sell some textbooks but mainly cater to a broader customer base. Your store always stocks the latest fiction,...

Q:

1. Who is Zeno? 2. Name an idea that Zeno is famous for?

Q:

According to the life-cycle/permanent-income hypothesis, consumption depends on the present discounted value of income. An increase in the real interest rate will make future income worth less,...

Q:

Which of the following refers to ownership in a company? stock, IRA, certificate of deposit, or bond

Q:

A new gas delivery system will be introduced by the gas division of Bronze Power, based on fixed costs per period of $ 4 , 2 3 6 ; variable cost per unit of $ 1 6 8 ; selling price per unit of $ 2 1...