ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   v.2003 - Scale problem in 2 X-Axis Chart (https://www.excelbanter.com/charts-charting-excel/161689-v-2003-scale-problem-2-x-axis-chart.html)

Ruprecht

v.2003 - Scale problem in 2 X-Axis Chart
 
nI have 5 lines of data represented on a side-by-side bar chart plus a dummy
line of zero data between 2 & 3 to separate the data between primary &
secondary axes. Works visually - except one of the 3 secondary data sets,
while grouped as 3 with the other 2 secondary colums (looks right) however,
it visually is scaled to the wrong (primary) axis.

Q. How do I get the rogue data to conform to the secondary axis scale ?
--
Rupey

David Biddulph[_2_]

v.2003 - Scale problem in 2 X-Axis Chart
 
Format Data Series/ Axis tab.
--
David Biddulph

"Ruprecht" wrote in message
...
nI have 5 lines of data represented on a side-by-side bar chart plus a
dummy
line of zero data between 2 & 3 to separate the data between primary &
secondary axes. Works visually - except one of the 3 secondary data sets,
while grouped as 3 with the other 2 secondary colums (looks right)
however,
it visually is scaled to the wrong (primary) axis.

Q. How do I get the rogue data to conform to the secondary axis scale ?
--
Rupey





All times are GMT +1. The time now is 07:20 AM.

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