Search results for query: *

I have a column of numbers (see 'Qty' column on attached file) that need to be divided in half and the resulting values placed in columns b and c. I use the ROUND function in order to do the calculation. However, when the 'parts' are added together, the sum does not always add back up to the...

Skip - Per your request, here's a copy of my 2nd inquiry about adding 2nd Data Validation column in Google Sheet document. Thank you. (Same Excel worksheet attached before upload to Google Sheets.) --------------------------------- Hello again. In an 'ideal' world is there a way of doing the...

I needed to create a listing that had a column with Data Validation (DV). Once someone selects from the column with DV, that selection is no longer 'available' for others to choose. This is accomplish using other formulas from a solution provided by a website (URL listed in the attached Excel...

Is there a way to include Microsoft Excel's conditional formatting icon set inside a chart -- as either part of the data label or attached to chart as part of the data table (or other solution)? I've not had success in doing so using Excel features on the ribbon. The closest I've come is an...

I have Excel cells that include conditional formatting (icon set) in a 'helper' column. These cells are linked to a report that's in PowerPoint *using Paste Special >> Paste Link Microsoft Excel Worksheet Object). It's been noticed that when converting the final report to a PDF before...

I've been linking certain Excel cells to PowerPoint by executing the following steps: 1. In Excel, highlight certain cells (e.g. L13:o18). 2. Select 'Copy'. 3. Switch to PPT and click on 'Paste Special' located on the 'Home' tab on the ribbon, 4. Select 'Paste Link' radio button option...

I've been trying to graph something that is required to fit in a very small amount of space. While the bars are readable, the labels and axis information are barely distinguishable. After spending a lot of time and trying different graphs, success has not yet been met and am looking for ideas...

Currently in the process of recreating a dashboard due to change in requirements. Historically, the dashboard in question was a multi-page document -- 6 pp. when printed -- that now needs to be consolidated to a one-page document. The first version of the new dashboard started in Excel...

I need to create a chart that shows the active-not active status of several products within a given time period and found a solution online. However, I want to add a secondary vertical axis that would contain each product name and have not been able to successfully accomplish this. As a...