Search results

I figured it out. I went to the 'Fill' tab under formatting and clicked the 'Clear' button and that worked. Thank you.

In the attached file, when column B evaluates to #N/A a red font is applied, and the underlying table style shows through which is fine. However, when column B returns a match, a green font is applied, but the underlying table style is overwritten. What is causing this?

The X-axis values default to 1,2,3 and 4. I am trying to get the values in DTE (column D) to be the X-axis values.

I had to rearrange things a little bit to be more clear. 1. Start from a blank cell in N5 2. In cell N5, the user would select a strike price from the data validation drop-down menu 3. Then the user can click the spinner button in cell M5 to adjust the strike price up or down. As they adjust...

Yes, that's what I was trying to do. I studied your spreadsheet. I have some questions. 1. You are plotting the data series 'Stock' as a stacked area chart with 'no fill' for the background. Then you are plotting the data series 'Shade' as a stacked area chart with a value of 50. It looks like...

I'm not sure what you mean.

I got it to work. Thank you very much!

Sorry my intentions were not clear enough. This attached pic shows what I was hoping to achieve. If Method 2 was used, the gray line would be "behind" the blue line so it wouldn't be visible, but it's data label ($0.10) would still be showing which is what I am trying to achieve. For clarity I...

1. The stock value is 500. Instead of shading below 500, I want to shade above 500. This attached pic shows what I was hoping to achieve. I used a green background in this pic. So just shading above 500, instead of below 500. 2. Another problem is that I would like to expand the lower and upper...

For this example, in the attached file I am concerned with only the following two data series/lines: Short put (column F) Short put price (column H) Each strike price in column B has an associated option price in columns C and D. For this example I am using the BID prices in column C, because...

Right click the spin button > Format Control. Is it possible to link the Current value and Incremental Change fields to a cell in the spreadsheet? If not, can this be done with VBA? If so, can you recommend any websites?

I am plotting column E (stock price) as an area chart, but I want the shading to apply above the stock price. I tried adding this to a secondary axis and reversing the axis order but that didn't work. Any suggestions?

I ended up creating a new tab and a new table. I think I might had added new columns with these features, then extended the table to include these columns, and maybe that's why it's acting this way.

I have a table saved in table format. When I add a new row, the formulas and the data validation list doesn't automatically appear in the newly added rows like it used to. What is causing this, and how can I fix this? I am unable to post a file because of confidential company data.

Thanks.

If you see the formula that I tried, you will be able to see what I was trying to do.

I was trying to hyperlink the words "Project Long Name" instead of the entire sentence.

On the first tab in C5 I have some text and I'm trying to use the hyperlink function to hyperlink the words Project Long Name. This involves concatenating text with the hyperlink function, then concatenating the remaining text. When the user clicks Project Long Name, the user would be taken to...

This filter functions is awesome. I didn't know about it. I was able to get what I need. Thank you everybody for your help.

I'm trying to replicate the screenshot I posted above. It looks close, but still a bit off.

Is it possible to add vertical grid lines to a pivot chart at each price on the X-axis?

This looks similar to an area chart but not quite.

On the 'Reference' tab in column G, I am trying to come up with a formula in the yellow cells that would return the values in the yellow cells. Starting in G2, I want to use some lookup function that uses G1 as a lookup value, then points to column B in the 'Consolidated' tab, and returns all...

Thank you.

In the attached file, I want months to be on the X-axis. On the Y-axis I want to plot the # of "Completed" cases. For example, September has 9 rows, so plot 9. October has 20 rows, so plot 20.