I have to do a lot of work in excel i always have to coampare the sales and have to solve different qureys which my boss ask right now i have data which has comparivitve sales of 3 months i want to use colours to tell wher sales is dipping and sort by colour
An expert who has achieved level 3 by getting 1000 points
An expert that got 10 achievements.
An expert that got 5 achievements.
An expert whose answer got voted for 100 times.
Re: i have data in excel
Excel cannot search by colour, however you can rank by adding a column, in which you place a ranking value (if you colour code as well you can appear to rank by colour), sorting by the ranking column will give you the same ranked rows together in numerical order.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
TRY THE GOODWILL STORES AND THRIFT STORES ,
THAT'S THE PLACES TO GO TO AND GARAGE SALES WHEN
YOU GO TO THE GARAGE SALE ASK FOR WHAT YOU'R
LOOKING FOR SOME TIMES PEOPLE HAVE STUFF THAT
THEY DON'T USE,.SO YOU ASK.?
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.
Ok, I realized that I wasn't paying attention when I created my test spreadsheet. My first cell wasn't sorting properly because it started with a ";" instead of a letter, so it always stayed at the top. I removed the extra character and repalced it with another letter, tried it again and it worked. If there's only 1 column, it doesn't ask to expand the selection. If there are nearby data cells, it asks you what you want to do. I was able to get it to work every time by selecting "Continue with existing selection" instead of "Expand selection".
Im Sure You Solved This Problem But For Other User Yes There Is A Way To Save Your Data If Your Hard Drive Is Still Operable. You Can Put Your Boss Hard Drive Into Your Computer And Copy Its Contents To Your Computers Hard Drive. Some Say That If The Hard Drive Is Not Operating You Can Put It In A Ziplock And Then Stick It In The Freezer For An Hour Then Attempt To Retrieve Your Info. Remember Always Back Up Your Data On Hard Drive Recorders As They Are Not Fail Safe.
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.