ser

Hi, I wonder if someone can help. I need to write either a long IF formula or maybe VBA – I’m just not sure! I have a spreadsheet with a number of columns and rows and I need to pick up data from a separate sheet in the workbook depending on the information in specific cells. So in row I...

Hello - I found this VBA that changes the data series for all of the charts in my workbook. Works great. 1. How do I change so that it only changes the charts on a sheet, and not the entire workbook... 2. Possible to also only change selected charts? Thank you. Sub ChangeAllCharts()...

Hi, Wrote this code to run and format three series everytime a pivot table updates. With three series I am formatting the colours of all three and the making the third series a secondary axis and a line chart. What am I doing wrong? the macro is not running everytime I select a slice Sub...

Fellow sufferers! I wish to adjust a graph so that the y-axis is only just long enough to accomodate . Also, the physical distance on the screen from 0 to 1 mark shall be fixed. The .Height = adjusts the height of the graph itself. I need to adjust the y-axis (and consequently the height of...