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!
-
Congratulations gkittelson 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: *
- Users: JonPeltier
- Order by date
-
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- JonPeltier
- Post #4
- Forum: Microsoft: Office
-
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...- JonPeltier
- Post #6
- Forum: Microsoft: Office
-
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...- JonPeltier
- Post #7
- Forum: Microsoft: Office
-
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...- JonPeltier
- Post #4
- Forum: Microsoft: Office
