Hi
Is there any way to have two different Y values I.e. one one the left in millions and the one on the right in 100s? both relating to the data on the X axis?
thank you
Hi,
Have you tried, Chart wizard > Custom types > Line Column on 2 axis
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Hi,
Me too want the same chart format.
But Line Column on 2 axis shows the second data series as line.
Is it possible to represent both the data series as bar in the graph, and both the series have to refer diferent Y values.
Thanks.
Hi,
If you click on the line, right click, chart type, pick column. you will now need to right click on the columns and adjust the overlaps, so right click, select Format Data Series > Options and adjust the overlap and gap width till things look right. You will need to do this on each series.
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
changing y axis scale with data table info
is there any way to change the y axis using a data table
info so that on a selected item the scale will change
accordingly.
for example: set up a run chart to fill in using a vlookup
for limits on horizontal plane and the averages of the
values plotted as tested, but change the item to a
higher/lower target and limits and have the y axis change
with the new data?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks