Creating an in cell bar graph that shows the position of a number within a range

Hi Jc3_ky,

Thanks for contacting us,

To create an in-cell bar graph that shows the stock price in relation to the 52 week high and low, you can follow these steps:

• Arrange your data in three columns, such as Stock, Price, and Range. The Range column should contain the difference between the 52 week high and low for each stock.
• Select the Price column and go to the Home tab. Click on Conditional Formatting > Data Bars > More Rules.
• In the New Formatting Rule dialog box, choose Format all cells based on their values and select Data Bar as the format style. Check the Show Bar Only option to hide the numeric values. Choose a solid fill color for the bars. Under Minimum and Maximum, select Number as the type and enter 0 as the value for both. This will make the bars start from zero and span across the cell width.
• Click OK to apply the formatting rule. You will see the in-cell bar graphs for the stock prices in the Price column.
• To show the position of the stock price within the range, you can add another column that calculates the percentage of the price relative to the range. For example, you can use the formula =B2/C2*100, where B2 is the price and C2 is the range. Then, you can format the percentage column as Number with zero decimal places.

Let me know if this helps or if you need further assistance.

Regards, Sola

“Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below. “

Kindly note that this is a user to user forum, we are users helping other users, we aren't Microsoft employee neither are we Microsoft agents.