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 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 do I go about it? Any help would be appreciated. Thanks...potsandpans



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


1 Suggested Answer

  • 2 Answers

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

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

2 Answers

What is excel


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.


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
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

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

Invoice & Order Minimize Data Entry - Especially Name and Address

Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.

Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.

Jan 06, 2009 | Microsoft Excel for PC

1 Answer


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

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 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