Is there a shortcut for placing an X in a column based on the data in another column? For example, if column A has a value "red" can I get Excel to automatically place an X in column B, but NOT if Column A says "blue"?
A shortcut for copying an X into a Column B based on data in Column A
ms office
Related Solutions
EDIT (Complete revision):
Based on your data, the only way to accomplish this without redesigning the table is to create separate charts for each Segment shown. As each segment has 4 pieces of data, this is the only way to do this. (There may be someone out there who is a charting expert that could do much better, I'm sure)
First, as you have done is to make a Total chart:
Then crate separate charts, positioned together for the segments:
The charts can be edited for looks and data views in the Inspector but that is beyond the scope of the question.
Sounds like Conditional Format is what you are looking for.
Select the cell which have to be formatted and choose Format->Conditional Format in the menu of Excel.
For more information have a look at: use a formula to apply conditional formatting
Related Question
- Numbers – Get First Cell Not Containing Certain Text
- Excel for Mac – How to Hide Unused Rows
- MacOS – Excel API data query – populates into a single column
- Auto-Populate Cell with Date in Numbers – How to Guide
- Write a Rule to Categorize Emails Based on Body Content in Outlook for Mac 2016
- How to i have numbers from 2 columns match and return a third result
Best Answer
Put a formula into column B (e.g. in cell B1)
You can also stack the
ifs for different values