Search : in
By :

How do I customize Line charts in Excel vista

Last answer on Jun 15, 2009 4:30:18 pm BST Mel77, on Jun 15, 2009 3:50:39 pm BST 
 Report this message to moderators

Hello,

I need to add a secondary "y" axis in order to show a different scale for a trend line. In the previous version, you would just click on "custom charts", add a secondary "y" line and move the data to the new axis. Does anybody know how to do this in Vista? I can't find anything remotely similar :-(
Thank you!

Configuration: Windows XP Internet Explorer 7.0

Best answers for « How do I customize Line charts in Excel vista » in :
Unable to initiate a DDE link with Excel Show Unable to initiate a DDE link with Excel During an attempt to email of a excel sheet, Microsoft word display a message that it is unable to initiate a DDE link with Microsoft excel. To solve out this problem, save the excel sheet...
Pie chart in excel Show
Excel Macro to create a chart Show
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
[Linux]Disk verification using fsck ShowDisk verification using fsck Intro Solution Intro Linux disk verification is done using the command fsck. However, for security constraints concerning the data present on the disk, it is strongly advised not to launch fsck from on a...
Download Point & Figure Charts Show
Download Comparison Chart ShowComparison Chart is a tool for comparing your products in a chart. With this tool, it is possible to have a graphical view of your products and compare the obtained results. It allows you to customize your chart by using texts, background colors,...
Download Chartz Show
Environment variables ShowEnvironment variables An environment variable is a dynamic value loaded into the memory that can be used by several processes operating simultaneously. On most operating systems, the location of some libraries or of the main system executables may...
Creating an ad hoc WiFi network ShowPresentation of the ad hoc WiFi network If you have two or more computers equipped with wireless adapters (WiFi cards), it is possible to easily connect them in a network by setting up a so-called "ad hoc" network, that is, a computer-to-computer...
Ask your question Reply

1

 Mel77, on Jun 15, 2009 4:30:18 pm BST

Ah!
Found it.
In a chart, click the data series that you want to plot along a secondary vertical axis, or do the following to select the data series from a list of chart elements:
Click the chart.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.

On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the data series that you want to plot along a secondary vertical axis.

On the Format tab, in the Current Selection group, click Format Selection.
Click Series Options if it's not selected, and then under Plot Series On, click Secondary Axis and then click Close.
On the Layout tab, in the Axes group, click Axes.
Click Secondary Vertical Axis, and then click the display option that you want.
Tip To help distinguish the secondary axis, you can change the chart type for just one data series. For example, you can change one data series to a line chart.

   
Reply to Mel77
Ask your question Reply
They need your help