Question about Computers & Internet

1 Answer

EXCEL When I generate a bar graph in excel how do I make the highest bar a different color automatically?  The chart generates itself as data is input into the spreadsheet.  Is there a way to get the bar with the max data to turn red, let's say, when the rest of the bars are blue? Also...I have 13 sheets in a workbook.  Each sheet has many formulas that I don't want the users to mess up...so I lock them and allow input only in those cells that require data.  I lock and protect each sheet individually.  Is there a way to lock and protect all sheet in a workbook at the same time without having to do each sheet individually?  I have over 25 people who use these spreadsheets and 25 x 13 is a lot of times to lock and protect.  Thank you all for your inputs into these 2 problems.  Pots and Pans

Posted by on

  • potsandpans Jan 09, 2008

    Do you have a suggestion as to how that macro should read? I have not written many macros...how do I go about it? Any help would be appreciated. Thanks...potsandpans

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

I have solution for your second problem.
You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.

This will save some your valuable time.

Posted on Jan 09, 2008

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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

3 Answers

What is excel


Hi,

Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

1 Answer

How to make tally charts on my laptop?


To create a tally chart in a laptop,the laptop must a spreadsheet package like Microsoft excel

these are the steps involve
-select the data to be use for graph.include the column and row label in sections
-select data
-click on number tab
-click on text
-click ok
-click on chart wizard icon on the tool bar
or
click on insert on menu bar
click on standard tab or custom types tab
under chart type list ,click to select the desire chart type eg tally.
under chart sub -type list,click to select the chart desire.
click on next button.
click on data range tab under series to select rows or columns.
click on next button.
that solve it.I hope you"ll find the solution post useful,dont forget to leave your comment by saying hope hopeful this post is to you

Oct 07, 2010 | Computers & Internet

1 Answer

I need to generate a graph (graphing trignometric equation in parametric form). The equations are, x=3cos(teta) y=2sin(2teta) We are getting error while generating


At first, you have to use t symbol for parametric functions when you operating with TI 89 Titanium. In your case you must input your relations as x1=3cos(t) and y1=2sin(2t). Then graphing it. See captured image


3_8_2012_6_57_35_pm.jpg

Sep 21, 2010 | Texas Instruments TI-89 Calculator

1 Answer

What's data series in excel


When you are creating charts in Excel a data series refers to the sets of values that are going to be on the chart, be it a line chart, a bar chart, a pie chart etc. Different types of charts can work with different kinds of series. If you select the data you want to chart, and use the Chart Wizard, it will detect what data you have chosen and define it into series for the purposes of being on the chart. You can do things like give names to the series or set colours for them or put titles and legends on the charts for them, and lots of other things. When you are working with a chart, a Chart menu will appear on the menu bar and there are options in it to do things with the different series that are in it.

Mar 12, 2010 | Dell Computers & Internet

1 Answer

Does the Graph/Chart option exist for Mac Excel?


Yes, it does.

Choose the data in which you want to graph by highlighting said data, including and row/column headings. Then click the icon, which looks like a graph, in the top toolbar which will open up the Chart and Graph Wizard. Then follow the steps and guidelines to create your chart or graph.

Hope this helps. Have a great evening!

Feb 17, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Excel


i have 2 columns in an excel. One column has data like a,b,c,d,e,f,g,h,i,j,k,l and the other column has values like 0,1,2,3,0,0,0,0,0,5,8,0 respectively. Now i have to generate a graph(pie chart and column chart). But the graphs should not have data and values that have 0 values. i.e, the graph should contain these data and values respectively. data: b,c,d,j,k values: 1,2,3,5,8.

Sep 23, 2007 | Microsoft Office Standard for PC

1 Answer

Microsoft excel(data analysing)


Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.

Sep 22, 2007 | Microsoft Office Standard for PC

1 Answer

Excel 2007


Darcy,select the data and then open the graph option then put the values

Sep 20, 2007 | Microsoft Office Standard for PC

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

Related Topics:

179 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...