Click on the, format Selection option on the left side of the ribbon to open the.
Format Data Series dialog box.
Moving the temperature data to a second vertical axis - displayed on the right side of the chart allows for separate scales for the two data ranges.Related Excel Tutorials, excel THE smart WAY, ebook 51 Excel Tips to Save Time Increase Productivity.Format it the way you want.The way around this is to have a different axis for profit margin.Here is how you can do this: Click on any of the Profit windows xp cd boot margin bar.Click once on one of the plot area of the chart to select.Click on the, design tab of the ribbon if necessary.Making Formatting Changes Using the Formatting Task Pane.Does anyone know how to create a Gantt chart in Excel?, andy Pope, Microsoft MVP - Excel fo, register To Reply.Formatting the X Axis Line, the X axis line is present above the X axis labels (cookie names but, like the gridlines, it is difficult to see because of the gray background of the chart.A combination chart (as shown below) is an apt way of doing this.Right-click and select Change Series Chart Type.Solid line, set the gridline color to, orange, Accent 2, Darker.In Excel 2013, when activated, the pane appears on the right-hand side of the Excel screen as shown in the image above.You would be able to see a vertical axis on the right of the chart.Formatting Task pane - the heading at the top the pane should.
Hi, A good place to start looking from.
Changing the Gridlines' Color, in the graph, click once on the 60,000 gridline running through the middle of the graph - all the gridlines sql server reduce database file size should be highlighted (blue and white dots at the end of each gridline).This will plot Profit Margin Data in a secondary Axis.Click on the X axis labels to highlight the X axis line In the formatting task pane, as shown in the image above, set the line type to Solid line Set the axis line color to Orange, Accent 2, Darker 25 Set the axis line.Click on the, add Chart Element option on the left side of the ribbon to open the drop down menu.05 of 09, moving Data to the Secondary Y Axis.In the drop-down menu, click.
Related Tutorials: excel - lent!
Format Major Gridlines, in the pane, set the line type.