Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JonPeltier

    Charting in Excel 2013 - Horizontal Category Axis Label

    Alternatively, type Alt+Enter in the cells where you want line feeds. ----------- Jon Peltier Peltier Technical Services, Inc. http://PeltierTech.com/WordPress
  2. JonPeltier

    Excel Chart Type?

    I am not familiar with your function. In any case, you have X and Y values, presumably this function helps you determine UCL and LCL, and you can then determine how large the positive and negative error bars must be. You can name your ranges for the error bar values the same as you can for the...
  3. JonPeltier

    Excel: Conditional formatting in VB - Problems pasting data

    Since the formatting is static after you apply it, if the values change, the Worksheet_Change event is needed to reapply the formatting. If you insert rows with data, you will have to reapply the formatting (rerun the code) on these new rows. You also will have to keep track of the size of the...
  4. JonPeltier

    Excel Chart Type?

    Here's another approach. Put your X values or labels into a column, and your Y values into the next column. Use a formula to calculate the (UCL minus value) for each point into the third column, and another formula to calculate (value - LCL) into the fourth column. Make a chart with the first...

Part and Inventory Search

Back
Top