I have a line chart with two lines in it. Sometimes the values between them differ by a hundred or more. That leaves the bottom line looking very flat. I want both of these to remain 开发者_开发百科on the same graph but is there a way to have a different scale for each line?
I was told that it is possible to have one (scale) on the left and one on the right, but I have googled and googled and have not found anything useful.
So any help would be great, thanks!
In the properties for the chart series change the ValueAxisName to Secondary
OR
- Right-click on the chart series
- Goto Series Properties
- Goto Axes and Chart Areas
- Change the value Axis to Secondary
精彩评论