Smart Add Tick Marks In Excel Graph

Format the secondary Y axis to have values in reverse order.

Add tick marks in excel graph. Would like some help with graph tick marks in WordExcel I am currently doing a scatter plot graph in a negative axis. Now to need to link the checkbox to a cell in Excel. Follow the setup instructions for the check box interactive example above but dont add check boxes in cells A3A5.

Move this to the secondary axis. Use Chart Options to enable the secondary X axis. For most Excel chart types the newly created.

I require a format where the major tick marks to be above the numbers on the X axis. In the Edit Series dialog enter a name for your data series I chose reference and select the X values you entered from Step 2. Add minor tick marks to a graph Double-click the axis on which you want to display minor tick marks.

Select a cell where you want to insert a checkmark. You are almost there we need to hide the orange series and a few axes. Select the cells you will insert tick mark or tick box go to Font group under Home tab and select Wingdings from the font list.

In the Symbol dialog box on the Symbols tab click the drop-down arrow next to the Font box and select Wingdings. Press with left mouse button on Design tab on the ribbon and then Add Chart Element. Clear the X to remove the series from the chart.

Add a new data series by right-clicking the graph and choosing Select Data. Under Low select Minor ticks. Click anywhere within your Excel graph to activate the Chart Tools tabs on the ribbon.