ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   My Custom Line-Column 2 axes Chart dsn't work with +6sets of cells (https://www.excelbanter.com/charts-charting-excel/39188-my-custom-line-column-2-axes-chart-dsnt-work-6sets-cells.html)

Tim

My Custom Line-Column 2 axes Chart dsn't work with +6sets of cells
 
I created a custom Line-Column 2 axes chart with 6 columns and it worked
fine, showing two different Y axis. Then I tried to do the exact same process
with a larger data set, with 10 rows again, but this time 12 columns, and it
doensn't work - it repeats the 12 columns twice, instead of recognizing that
I want the 2 sets of 12 on top of one another, like 2 layers, each with a
different Y axis. Any ideas on how to avoid this? I think it may be a flaw in
the software because, literally, when I delete half the cells and run the
same process, it works... it just doen'st seem t o know what to do with more
than 6 columns... :(

Thanks for any ideas...


All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com