How to put column and scatter chart on same x-axis in Excel?
-
I'm having some trouble with Excel: I need to plot a scatter chart and column chart on one graph. Both the column chart and scatter chart correspond to dates on the x-axis. They each have different y-axis values, and so are aligned with different axes. For some reason, my column chart does not line up properly with the x-axis, and dates are way off. However, when I switch the column chart to a scatter chart, it lines up perfectly (meaning I don't think the problem lies in the data I've entered). Has anyone experienced this problem before/does anyone very advanced in Excel want to help me work on this problem by email? I've brought this problem to my university's Excel teacher and he couldn't figure it out (this is for an independent research project, not for an assignment). Also, please let me know if you need me to clarify anything. Thank you!
-
Answer:
You'll likely find the answer here: http://peltiertech.com/Excel/Charts/ComboCharts.html Seems you might have to tweak one of the charts' axis source data.
ENigma 1201 at Yahoo! Answers Visit the source
Related Q & A:
- How to set column as readonly on Gridview?Best solution by Stack Overflow
- How can I auto run ccleaner on Mac OS X?Best solution by forum.piriform.com
- How to split column text to another column?Best solution by Stack Overflow
- How to create column chart with Google charts?Best solution by developers.google.com
- How to change column data's as a separate column wise format in a SQL Server?Best solution by stackoverflow.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.