Question about Computers & Internet

1 Answer

Want to write a code in VBA for a Chart prepared in Excel

I have prepared a calculation chart in excel which calculates the steel in kgs required for the given pile.Since there are 6 different types piles with different steel requirement,i used if conditions to solve them in excel.But it is not sufficient,as I cannot write them in summary sheet.Now I calculate the steel in one sheet and then link in the summary,which consumes time,labor and is also error prone...Can you guys help me...I know I 'm being too optimistic on that score...

Posted by on

  • Rabins Sharma
    Rabins Sharma May 11, 2010

    Please mention all required details.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 183 Answers

Dear Customer,

you have not define your all details,

Plz give all details than & only than some can help you ,

so,Please mention all required details

THNX

Posted on May 17, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Why did i choose microsoft excel lab?


To create some spread sheet of datas.
Crate some Commercial calculation as well as Graphical charts such as pie chart,bar chart .
Excel is ocean bro.

Jul 09, 2014 | Computers & Internet

3 Answers

223 bullet drop chart


The best way to generate that chart is by shooting over a chrono and inputting the data into an external ballistics calculator, such as this one by Hornady:

Ballistics Calculator


It takes some work to gather the data, but it's much more accurate than any generic chart can be. I've used cards generated by a couple of different online calculators and have gotten better than acceptable results out of them with both my match barrelled 5.56 AR carbine and 7.61x51 Savage 10FCP. Good enough to ring 6" steels at 300 yards and 500 yards, respectively.

There are many other web-based calculators that can do the job, just search for "external ballistics calculator" for more.

May 26, 2014 | Optics

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

1 Answer

Excel Charts in PPT 2003 and 2007 not working correctly


Have you tried uninstalling the beta, and possibly uninstalling and reinstalling your copy of Office 2003?

Jan 26, 2009 | Microsoft Excel for PC

1 Answer

Excel report


Depending on what you are doing, you either are presenting data or a chart, pivot table. Those have to be prepared within Excel to produce the report.

Jul 21, 2008 | Microsoft Computers & Internet

1 Answer

Data for excel chart


You need to create subtotals so that it looks like something like this:

Prod/units Amt. Level Total

xxxx 10.00 1
yyyy 20.00 1
30.00

dddd 40.00 2
ffff 30.00 2
70.00

etc.

To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.

If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.

Some reading:
http://www.ehow.com/how_13020_pivot-table-wizard.html
http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Also Google "Excel pivot table wizard" to get more.

Good luck!

Feb 23, 2008 | Microsoft Office Standard for PC

3 Answers

Excel vba password recovery


You can but you will need software. Search for google for VBA password recovery tools. Search for the appropriate crack you have it all . .

Dec 30, 2007 | Microsoft Excel for PC

1 Answer

Outlook automation from Excel


you can send an excel page or chart as an email. you can do this direct from excel, however the receipient will need excel to read it

Sep 28, 2007 | Microsoft Office Standard for PC

1 Answer

Stacked Bar/Column chart with Negative Values


use a line chart instead with up/down bars

Nov 01, 2006 | Harvard ChartXL 3.0 (163103)

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

124 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...