Clustered Bar chart

This assignment uses VbaHwk1.xlsm workbook. Open it – you should see a “Sheet1” worksheet that contains sales figures from January to March for four cities. Using this worksheet, you need to record a macro that creates a Clustered Bar chart. After you finish recording the macro, you will have to clean and compact it.

Step 1: Record the Macro 1. First, practice how to create a Clustered Bar chart. Be sure that the “Sheet1” worksheet is the active worksheet.

Don't use plagiarized sources. Get Your Custom Essay on
Clustered Bar chart
Get a plagiarism free paperJust from $13/Page
Order Essay
  1. Select range A3:E6.
  2. On the Insert tab, click the Bar icon in the Charts group.
  3. Click the Clustered Bar chart type in the 2-D Bar section to insert a chart. Note: as you move the mouse over the palette, a Screen Tip appears that shows the name of the chart type.
  4. Click once on the empty space somewhere near the top-right corner of the chart area to make the chart object active. Click the Layout tab, click Chart Title in the Labels group, and then click Above Chart to create a title for the chart.
  5. Type Sales Figures for the title and then click once anywhere on the empty space somewhere near the top-right corner of the chart area.
  6. Now, we want to move the chart to a new location. Click the Design tab and then click the Move Chart in the Location group. At this point, the Move Chart window is open. Select the New sheet option and then type Sales Chart as the name of the chart sheet. Click the OK button to dismiss the Move Chart window. At this point, you should see a new Sales Chart sheet that contains the Clustered Bar chart object.

 

  1. After successfully creating the Clustered Bar chart, you can delete that Sales Chart sheet and then recreate it. Repeat the process of creating and deleting a Clustered Bar chart several times until you are satisfied and comfortable with the process.
  2. Be sure you delete the Sales Chart sheet from the workbook. Now, you record a macro that will capture the steps – 1(a)-(f) above – that you do to create the Clustered Bar chart. You can name the macro Macro1 or VbaHwk1 or any other suitable name. Be sure to stop recording after finishing the above steps.
  3. Test your macro to make sure it does what it is supposed to do. Before running the macro, be sure that you delete the existing Sales Chart sheet; otherwise, your macro will generate an error message because it would not be able to perform the task described in step 1(f) above. If your macro works as expected, save it.

Homework Valley
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.

Free Revisions

All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.

Title-page

A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.

Bibliography

Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.

Originality & Security

At Homework Valley, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.

24/7 Customer Support

Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

We work around the clock to see best customer experience.

Pricing

Flexible Pricing

Our prices are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.

Communication

Admission help & Client-Writer Contact

When you need to elaborate something further to your writer, we provide that button.

Deadlines

Paper Submission

We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.

Reviews

Customer Feedback

Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.