Donate SIGN UP

Line Bar Charts in Excel

Avatar Image
funkylad20 | 15:09 Fri 27th Aug 2010 | Computers
4 Answers
I am wanting to create a barc hart with three values on in (high figures) and a LINE chart to go ver the top (which has very small figures).

Can anybody help?
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Are you asking how to create the chart or how to turn small figures into a comparable magnitude as the high figures (e.g. such as by multiplying the small figures to scale them up)?
I don't believe you can overlay charts in Excel. Someone else may know better though.
I think you'll find that if you click on the particular data you're trying to show on the line graph you can select the type of graph to use i.e. line and then selecting the axis tab will allow you to show this on a separate scale
This works with a combined Column and Line chart but not with a Bar and Line chart.

1 to 4 of 4rss feed

Do you know the answer?

Line Bar Charts in Excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.