Posts by melsmiff

Re: Formula Error When Control Box Checked

This seems to have fixed the problem for now! Thank you!

I have a formula that bring me back a figure (cell I3 attached) based on underlying data which works fine until I use the control box I have created to select the other option "poly". If this is checked then I just get an error and I cannot work out why.

Can anyone help me at all please?

Re: Currency Converter

I'm not sure this would work in this case. I actually want the data to change to the selected currency. I have attached the actual spreadsheet (a price calculator of sorts) so you can see what I am aiming to do a bit more clearly. I want to be able to click on the '$' or '€' button and have all the £ figures change to show the selected currency.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]I'm not sure this would work in this case. I actually want the data to change to the selected currency. I have attached a screen dump of what I am working on (a price calculator of sorts) so you can see what I am aiming to do a bit more clearly. I want to be able to click on the '$' or '€' button and have all the £ figures change to show the selected currency.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Also, most of the actual £ values are made up of formulas, I think this might make a difference

I am looking to write a small macro to convert all figures on a page to either EUR or $ at the click of a button. Can anyone suggest the best way to go about this?

Re: Don't Show Pivot Table Data If Page Field Has No Data

how can i build calculated fields actually 'into' the pivot table without overwriting existing data?

for example, is there a way to add extra columns at the end of the pivot table?

I have created a pivot table that breaks down 12 months of data and shows a total for each month and a grand total for the 12 month period.

What I then need to do is 'fix' these columns as when I change the product, if there is no data for a particular month then that column does not show up, therefore the extra formulas I have created at the end of the piviot table do not pick up the correct months data as the column is gone!

Does anyone have any suggestions?

I am trying to create a 3 dimensional stacked bar chart with an added dimension showing depth. I have attached a graphical example as I cannot work out how to do this using a chart. Any help would be greatly appreciated

I have a floating bar chart showing ranges. I need to add points to these ranges i.e. I have a range from 5-10 and I need to add points (dots) at 6 and then again at 8.I have tried using a scatter chart on top but it automatically puts onto a secondary axis therefore the points are not on top of the shaded range bar. (see attached)

Any suggestions on how to do this?

I have created a bell curve and I am trying to widen the curve slightly but I cant seem to do it without the curve moving from side to side, I need it to stay central but widen so is spanning above the smaller bars . Any suggestions?

Re: Conditional Formatting to highlight a date that is ≤ end of current month

Actually, this is a shared workbook so conditional formatting does not work, is there an alternative?

I want to use conditional formatting to highlight a cell (Column I) when the date is before or up until the end of the current month, I am struggling with this although I am sure it is very simple!

Re: VLookup with text

I am quite happy to try a pivot table but I thought you could only use this with numeric values? The responses I need are text. Would this work somehow?

Re: VLookup with text

updated copy

Re: VLookup with text

Batman - thanks for your suggestions. I have now introduced a show ID for consistency and added a published Y/N column. Am still unsure as to how to use the VLOOKUP function to do what i need through

Re: VLookup with text

very good point! Assume all the names in both A columns are not file names therefore will match. If the show doesn't exist on the July sheet then I want it to leave it as it is currently

I am trying to create a VLOOKUP formula for the attached spreadsheet. What I want is on the Gen Shows tab, on the Last Data Update column (C), I want to add a LOOKUP formula so that when the corresponding named show from the July tab shows as being published (column E), it needs to bring back the date from column D.

Re: Logo in header and footer

Have Excel 2000

I am trying to put a logo into the header of an excel worksheet so that it comes up on every page in the same place. However, I cant seem to be able to do this! Does anyone have any suggestions?

Re: Combining Charts

I explained what I was trying to do in a previous post called "Impossible Charts?" if you fancy a look?

Is it possible to combine a bar chart and a scatter chart?